Skip to Content
avatar image
Former Member

Numeric ID used in Member Formula not working properly

Hello experts,

I'm working with member formulas and I'm facing the following issue. I've a calculated account member (Account ID: 520000_001) and I need that member to has the same value of account 110505. I'm writing in 520000_001 FORMULAH2 property the ID "110505" (without quotes), and it's putting me in the reports in the account 520000_001 the value 110.505, and not the value of the 110505 account.

I've tried with the following syntax in the FORMULAH2 property:

110505 (Put the numeric value) - I know this syntax work because I'm using it with other alphanumeric ID's (ie. BG52500)

'110505 (Excel syntax for specifying an explicit text - Put the numeric value)

[110505] (Returns nothing)

[Cuenta].[110505] (Returns nothing)

[Cuenta].[H1].[110505] (Returns nothing)


The 110505 account has value, and i'm querying in the correct data region. We've 2 hierarchies, the account belongs to both ( I mean, it's present in a node in PARENTH1 and another node in PARENTH2).


Any clue?


Thanks in advance!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 03, 2015 at 03:43 PM

    Hi Andres,

    what do you mean by "I've a calculated account member (Account ID: 520000_001) and I need that member to has the same value of account 110505"? Is 520000_001 calculated as a parent in either of your two hierarchies? Or should it be calculated with the formula?

    How is 520000_001 used in the two hierarchies?

    BR,
    Arnold

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Andres,

      In my account dimension I have always just used [account] as the syntax and never specifically mentioned any hierarchy. I believe theoretically  [110505] should work as well as [Cuenta].[110505] as well as [Cuenta].[H2].[110505].

      BR,

      Arnold

  • Oct 29, 2015 at 08:53 AM

    Hi Andres,

    yes the cause is that your account 110505 it's just a number, dimension member sheet it's a normal excel worksheet so he isn't able to understand that you mean the account ID and not the value, this because in the formula it's possible to give a formula that contains also values.

    I think the possible solutions is to rename the accont transforming it in a string, e.g. 110505_0 or A110505.


    Another possibility instead of a formula is to set 520000_001 as a parent of 110505 but in this case I think you will have also future issues in the reports when you're using 110505 account.


    Watch out also using E letter, e.g. 110505E2 excel will use this as a number with scientific notation.


    Remember in all dimensions it's better never use numeric ID but a string with character inside.


    Regards

         Roberto

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Roberto,

      Thanks for your response. Is very strange, I mean, this is an account planning system, so it's just normal to use account codes as ID's for modeling...

      The parenth aproach isn't possible in this case, since the account would be used in many member formulas, so I would need a PARENTHN for each case.

      Any other suggestion?

      Thanks