question

bhojarajan_vtj avatar image
bhojarajan_vtj asked

MDX Calculated member

Hi Team I would like to transform the below sql query to an mdx calculated member expression. Select sum(sales) from table where empid in(select empid from where deptid in(1,2 )) Can someone please help me. Many Thanks in advance!!
sqlmdx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Martin Schoombee avatar image
Martin Schoombee answered
Could you provide some more details as to why it needs to be a calculated member? This can easily be done without the use of calculated members.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.