on 12-07-2017 3:13 PM
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
Sorry, but the properties will return string, not a memer I'd. Read about mdx statement strtomember...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.