February 14, 2005 at 5:08 am
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
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
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
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