i am trying to access invisible dimension in the reporting services surface. but it is giving error. is there any way to access invisible dimension in the reporting services surface. but this hidden dimension can access in the sql 2005 management server. but in the reporting services cant. pls tel m some way to do that.
pls give me the solution if anyone know about this.
|||
You cannot use Hidden Dimensions in SSRS.
But U can create Hidden Calculated Members in Cube, which U R creating in SSRS MDX.
Then use that Calculated Members in Report MDX Query, It will work fine.
Bhudev
|||thx dev
No comments:
Post a Comment