cancel
Showing results for 
Search instead for 
Did you mean: 

Use of dimension properties for tuple definition in member formula

simon_riveron
Discoverer
0 Kudos

Dear all,

I'd like to create a tuple from the account and category dimension as followed:

- the account can be defined as a fix element with ID ("B")

- the category should be defined as a dynamic element: the id I need is stored in the property "my_property" from the category dimension itself.

The formula I tried looks like:

my_member_formula = [ACCOUNT].[A]+([ACCOUNT].[B],[CATEGORY].CURRENTMEMBER.PROPERTIES("my_property"))

I get the error "internal error: no result set". It seems to me that the information of category dimension is missing (in other words that the property "my_property" should be allocated to the category ID itself).

System: BPC 10.1 NW on HANA (Parameter ENABLE_HANA_MDX is set)

Can someone help? Thank you in advance for your help!

BR

Simon

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

Sorry, but the properties will return string, not a memer I'd. Read about mdx statement strtomember...

former_member186338
Active Contributor
0 Kudos

P.S. Or strtotuple !

Not sure it's supported by hana mdx.

For function description please search Microsoft site.