This project has moved and is read-only. For the latest updates, please go here.

get the value for a set of members

Topics: Resolved
Sep 29, 2009 at 5:57 PM

Hi,

how can I insert a calculation like this in the olap pivottable extensions? I can use the "{ }" sintax for an array of members in a calculated member  of a cube, but i cannot use it in the olap pivottable extensions

 

(

{[product].[code].&[1],[product].[code].&[2]}, [measures].[Imports]

)

Sep 29, 2009 at 6:51 PM

try this as the formula:

Sum(
 {[product].[code].&[1],[product].[code].&[2]}
 , [measures].[Imports]
)

Marked as answer by furmangg on 6/10/2014 at 3:45 PM
Sep 30, 2009 at 9:48 AM
Edited Sep 30, 2009 at 11:17 AM

Thank you for reply, 

it works.

And if i have to add another dimension?

i want to have the "IMPORTS" where ([product].[code].&[1] or [product].[code].&[2]) and ([city].[name].&[name1] or [city].[name].&[name2] )

 

 

 

Sep 30, 2009 at 3:46 PM

Try this:

Sum(
 Existing {[product].[code].&[1],[product].[code].&[2]}
 , [measures].[Imports]
)

If you have further general MDX questions, this forum is not the proper place. Please post them here:
http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/threads/

 

Marked as answer by furmangg on 6/10/2014 at 3:45 PM