Skip to Content

Use of dimension properties for tuple definition in member formula

Dec 07, 2017 at 03:13 PM


avatar image

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!



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Dec 07, 2017 at 03:38 PM

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

P.S. Or strtotuple !

Not sure it's supported by hana mdx.

For function description please search Microsoft site.