Connecting Cube to Relational Database by Drill Through

Topics: Developer Forum, Project Management Forum, User Forum
Sep 20, 2012 at 6:54 AM

Hi ,

Can the calculated member in Cube be connected to a Relational database. I want to connect it for more detail and the data is in unaggregated form in the relational table.

Coordinator
Sep 20, 2012 at 7:18 AM

You can do this by creating an action. You could either create a report action and use SSRS to report against the relational data or you could use the SQLQuery class (see http://asstoredprocedures.codeplex.com/wikipage?title=SQLQuery&referringTitle=Home) and create a rowset action. The trickiest part of something like this would be mapping the context from the cube into an appropriate SQL query.