Export a file periodically from Consolidation Model with variable TIME members

[former_member239899]

Hi Experts,

After the consolidation process, I need to export periodically a file from the Consolidation Model (to the same place), where all members of all dimensions are constants, except TIME dimension, where I need (in each execution), six members... the current period of the current year and the previous two months, and the same three periods of the previous year...

Well, them I have thought about two possibilities:

1 Use Export Package with "/CPMB/EXPORT_TD_TO_FILE" chain

2 Use Export Package with "/CPMB/EXPORT_TD_TO_BADI" chain

1 With this chain (FILE), I be able to export a file, but I can not introduce TIME variable members of each execution. And, also, I can not invoke an Script file (where I could recover TIME members as I need)

2 With this chain (BADI), I be able to invoke a BADI, but I can not indicate the generation of a file...

Well, can I anybody help me?

Thank you in advance,

[former_member239899]

Hi Vadim,

With UJD_TEST_PACKAGE we need to export a lot of accounts (all of them belong to the same parent)... How can I do in order to set one "PARENT" in Answer Prompt instead of account by account individually?

With Answer Prompt BAS(PARENTH) we can´t achieve this behavior, the system doesn´t export any data, and account by account the PROMPT doesn´t allow a "prompt file" too big...

Can you help us please?

Thank you very much and regards,

[former_member186338]

Sorry, I do not understand what are you doing...

Have you created Z copy? What is the issue to generate in ABAP the list of base members?

[former_member239899]

Hi Vadim,

Yes we´ve created Z copy of UJD_TEST_PACKAGE.

In order to achieve the best and easy solution maintenance, we prefer send members in Answer Prompt, not after that with ABAP.

Instead of identify each base member, we need to use a sentence like "BAS(ACCOUNT)"...

You can see an example Prompt File attached...

Thank you very much for your help,

Prompt File.txt.zip

[former_member186338]

Sorry, but answer prompt never support things like BAS(ACCOUNT)!

You will have to generate list of members and place it in the generated answer prompt!

Another option is a saved filter, but:

1. Filter can be used only with some member property, no way to use something like BAS(ACCOUNT)

2. Filter is user specific

[former_member186338]

P.S. Anyway you have to generate TIME dimension members for the answer prompt!

[Former Member]

Vadim,

But in his case then he will have to manually create a new prompt file each month? Because he requires his job on daily basis....but what after the month changes...

JP

[former_member186338]

The answer prompt has to be generated inside the abap code of ZUJD_TEST_PACKAGE! And this code can use current system date!