Skip to Content
avatar image
Former Member

Use of dimension properties for tuple definition in member formula

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 07, 2017 at 03:38 PM

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

    Add comment
    10|10000 characters needed characters exceeded