June 4, 2012 at 2:20 am
Hi all,
we have SSAS 2008 cube and as reporting tool we are using excel 2007.
When is in excel created some report, after click on measure I will get detailed data - lowest level of cube.
But our users need to have access to detail source data from which was cube generated,
not only the lowest detail of cube.
Could you please advise how is it possible?
Thanks a lot for any help!
June 4, 2012 at 4:05 am
you are asking about cube access or the sql server source db access?
June 4, 2012 at 4:08 am
I am asking about source db access - in this case not sql server but oracle db 11g.
June 5, 2012 at 5:54 am
Have you looked at the drill down functionality? That may be one option.
June 13, 2012 at 4:17 am
Just to make things clear :
In Data Source View there is a star schema - fact table with 10 foreign keys to 10 dimensions. (and some measures..)
But cube is calculated only on 8 dimensions.
What I need to get to excel are relational data including attributes from 2 dimensions which arent used for calculation of the cube.
I tried to define drill through action , but i am not able to add dimensions which werent used in cube. (I am able to use only those 8 dimension used for cube)
Please help !
Thanks a lot !
June 13, 2012 at 6:37 am
Either you need to add the two dimensions to the cube or you can create a custom .net assembly / dll to execute a SQL Query and then add it to the drill through action. There are some of these already on codeplex.... I think as part of the assp project.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply