Post reply

T-SQL query from a cube to the datasource database.

  • February 14, 2005 at 5:08 am

    #109862

    Hi!

    I have a cube and two level Customers dimension in it: CustomerGroup -> Customer on Server1.  Customer level is built as Customer.CustId (for key) and Customer.CustName (for name).  The source database is located on Server2.  What will be an action syntax that will select data from Customer table in the source database where CustId equals the cube highlited cell CustId?

    Thanks.

  • February 16, 2005 at 8:38 pm

    #542683

    Have you tried using the built-in drill through functionality?  I'm assuming that the fact and dims are all on the same server (server2).  When setting up drill through in the model you can specify which fields from which (source) tables you'd like returned.

     

    Steve.

  • February 17, 2005 at 12:49 am

    #542713

    I am using it, but sometimes I need more flexibility than drill through functionality can offer.  If there no standard aproach for running such queries, is there any OLAP client software like Proclarity or Cognos, that allows to program such T-SQL queries?

     

  • February 20, 2005 at 5:16 pm

    #543247

    the following article could possibly help (it's about using AS and RS, look towards the end re: actions) but will depend a little on how dynamic you need to query.  If it's only ever going to return customers etc, then this may work for you.

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp

     

    steve.

    Steve.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply