Into Analysis Services Tutorial cube i defined the Internet Sales Details dimension (rolap storage) and a drill-through action ( Internet Sales Details colums to be displayed) following the tutorial steps.
Now browsing the cube with Cube Browser everything goes fine and the drillthrough works as expected.
Plus because i defined Internet Sales Details dimension to be not visible this dimension is correctly not visible into the cube browser.
However after generating the report model of the cube, when I use this model into Report Builder not only Internet Sales Details dimension is visible with all its colums but the drillthrough it's the standard one (lowest level of cube dimensions) instead of the one i defined and that appears into the cube browser.
How can i fix this issue
Thanks.
Report Builder Analysis Services Drillthrough.
Hot Topic
- Search Outlook (*.msg) files within SQL Server using full-text serach
- Log Shipping From SQL 2000 to SQL 2005, Can it be done?
- ROW_NUMBER() function in SQL 2005
- SSIS Requests...
- SQL Express user permissions?
- Help with XQuery formulation - selecting *only* most recent element from multiple table rows
- Attribute Relationships in Project Real
- Wich datatype?
- Get last record in a SQL database
- SSIS Requests...
SQL Server
- Migrate MSSQL 2005 Express -> MSSQL 2005 Srv
- Groupings in Matrix Layout?
- [264] An attempt was made to send an email when no email session has been established
- store procedures creation on prepare statment
- raw file source avoid bad data?
- Remote Debugging in SSIS ?
- A "not in"-lookup?
- Execute a package on a remote server
- Availability of SQL Server 2000
- Row and column count in SSMS
Report Builder Analysis Services Drillthrough.
Mjohnson
I resolved this issue modifying with an editor (notepad :-) ), the report model file. In this way I can leave into analysis services the dimension visible and I don't need to set drillthrough action because I can set all these properties directly into the report model.
I hope Microsoft will give use in future the possibility of editing report models coming from analysis services cubes with the Model Designer.
Alberto.