First of all, I am using OLAP data but it comes in form of a SAS DataSet so its not multi-dimensional anymore.
I need a kind of drill through, more a link to a detail table I guess, but not based on OLAP.
I just need some clarification on the drill through, coming from a Hyperion background I never had to specify the drill through specifics, so now with SAS I am a bit confused:
The documentation reads:
"However, if the cube was loaded from a star schema, a view that fully joins the star schema can be used as a drill-through table. "
In my case I want to use the very same fact table that build my OLAP cube. Is that feasible?
I want that the cube does not aggregate on the level
Sals Person, showing the number of contracts, for Karen Hys two, but not the contract details. All the contract details should be seen when clicking on Karen Hys (web report) and drilling through to the fact table.
Is that possible or do I misunderstand the concept of drill through?
The contract itself should not be part of the sales dimension since it is a small detail that does not matter often. nevertheless for each sales person all
the contract facts have to be summed up and the drill throug should only give the details of the individual contracts and how the sum was created.
Note: I am using OLAP data but it comes in form of a SAS DataSet so its not multi-dimensional anymore.
I need a kind of drill through, more a link to a detail sas oracle view I guess, that was originally used to build the cube.