You want to use a perspective in an mdx query. How do you select the perspective

You want to use a perspective in an mdx query. How do you select the perspective?

Question Posted / shivani goyal

1 Answers
253 Views
I also Faced
E-Mail Answers

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

Post New Answer

More SSRS SQL Server Reporting Services Interview Questions

How does the report manager work in SSRS?

1 Answers

Can you edit the .rdl code associated with a linked report?

1 Answers

what is the difference between Tabular and Matrix report?

1 Answers

How to create sub reports?

1 Answers

What is bookmark link in ssrs?

1 Answers

What is the report model project?

1 Answers

What are the export options of ssrs?

1 Answers

How to backup encryption key ?

1 Answers

what are the new features in SSRS?

1 Answers

In how many ways you can invoke ssrs reports?

1 Answers

User wants only to display only pdf as export option in report manager. How to achieve this?

1 Answers

what are the core components of SSRS?

1 Answers

For more SSRS SQL Server Reporting Services Interview Questions Click Here