Export transactional figures from summation accounts to CSV

[Former Member]

We want to export transactional total figures to  CSV. Not the details from the leaves but the figures on nodes level. Is there perhaps a predefined tool for that?

[former_member186338 · Accepted solution]

Standard export to text file will work! Select the required measure!

[Former Member · Accepted solution]

We tried with the Standard Export package from the Excel Interface but can select base accounts only:

[former_member186338 · Accepted solution]

Simply edit advanced DM script: instead of:

PROMPT(SELECTINPUT,,,,"%DIMS%",0)

Use:

PROMPT(SELECT,,,,"%DIMS%",0)

You will be able to select parents...

[former_member186338 · Accepted solution]

P.S. If the cube is periodic - select PERIODIC MEASURE:

Vadim

P.P.S. Selection of parent:

[Former Member · Accepted solution]

Thank you Vadim. Now indeed I could select(!) the total members. But then the system cannot find any figures for them:

[former_member186338 · Accepted solution]

Please read my message!

Not SIGNEDDATA MEASURE!!!

PERIODIC or YTD depending on cube!

[former_member186338 · Accepted solution]

If we are talking about Consolidation model looks like the measure will be YTD!

[Former Member · Accepted solution]

Perfect! Works fine now. Thank you!