Can you give hierarchy 1 and hierarchy 2 levels. little more info required.

Thanks for suggestion! I have removed Union.

I have edited my post. Pls check. I love MDX Studio for formatting. 🙂

You can try this:- Its perfect, you will just love it.

WITH

MEMBER Measures.MaxMonthValue AS

Max

(

...

It is :

SELECT [Measures].[Sales Amount Quota] ON COLUMNS,

[Customer].[Customer Geography].[Customer].&[11003] ON ROWS

FROM [Adventure Works]

You don't need to specify all Dimensions as others allmembers wiil be taken in account by default.

You will just love it...

WITH

MEMBER [Date].[Month of Year].YTDROR AS

Aggregate

(

Except

...

I can find out whether it is running serially or parallel. My concern is, is it possible or not. If it is possible how to do it so that my...

what is issue with your query ?

you can create a Client master db and connect to that db your RDL and create a table ClientDBList in master DB in which you have to maintain the connection...

+ It may also be possible, you may be using the removed tablix member in other tablix expressions(filter etc.)

agree!

Tricky Q?. I failed for sixth option where I missed the view is created with same name as table and synonym is now referencing view..

😉

Nice Q? However I did not get it right.

Dear,

I know this very old post but ..

Solution is:-

Use

Select @vCmd = 'echo ' + @vCLUEDATE + CHAR(254) + '> ' + @vWorkfilename

and then excute below bat file

copy below code...