You want to use a perspective in an mdx query. How do you select the perspective?
Answer / Manu Chaturvedi
To select a perspective in an MDX query within SSRS, use the WITH MEMBER statement with the CURRENT PERSPECTIVE keyword before defining the member. For example: WITH MEMBER [Measures].[Sales] AS ( [...] ) CURRENT PERSPECTIVE <PerspectiveName>
| Is This Answer Correct ? | 0 Yes | 0 No |
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
What is report snapshot?
How does the report manager work in SSRS?
Do I need a report server to run reports in my application?
Explain can you implement data mining in ssrs?
What programming language would you use to create embedded functions in ssrs?
What is report subscription?
How to create sub reports?
Name some of the open source software that you can use in alternative to SSR?
what are the different stages of Report Processing?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?