EPM - VBA syntax for Tuple functions

[Former Member]

Hi there,

In my business case, I realized that if I can get 3 reports into 1 report, then everything will be fine. After some research I have managed to use 'RemoveMemberFromColumnAxis' functions to remove members from Column Axis. After achieving this, I tried to use 'RemoveColumnTuple' for handling more complex reports but I can't.

I tried every syntax including string array but no result. Did anybody managed to use 'RemoveColumnTuple' or 'RemoveRowTuple' succesfully?

@Vadim,

I do not personally know you but if there is someone with an answer to my question, then I'm sure it is definitely you 😃

[former_member186338]

Hi ilter,

Can you explain what you want to achieve instead of how to use API functions RemoveColumnTuple/RemoveRowTuple - both undocumented!

Vadim

[Former Member]

Hi Vadim,

I have a report consists of 2 dimensions. TIME and Category. I have to override Category dimension from context for different years. You can find the details in attachments. But for here;

DIM 1 : TIME                  

DIM 2 : CATEGORY (Overriden by Context selection)

Context :  2014.FT.V12

Report 1	Report 1	Report 1	Report 2	Report 3
2011.12	2012.12	2013.12	2014.12	2014.12
ACTUAL	ACTUAL	ACTUAL	2014.FT.V12	2014.BUDGET.V00

If I can get this 3 reports into 1 report, then I can add another dimension on top of these 2 dimensions such as Company.

DIM 1 : COMPANY

DIM 2 : TIME

DIM 3 : CATEGORY (Overriden by Context selection

Context : 2014.FT.V12

Header 1	Header 2	Header 3	Header 4	Header 5	Header 6	Header 7	Header 8	Header 9	Header 10
Comp 1	Comp 1	Comp 1	Comp 1	Comp 1	Comp 2	Comp 2	Comp 2	Comp 2	Comp 2
2011.12	2012.12	2013.12	2014.12	2014.12	2011.12	2012.12	2013.12	2014.12	2014.12
ACTUAL	ACTUAL	ACTUAL	2014.FT.V12	2014.BUDGET.V00	ACTUAL	ACTUAL	ACTUAL	2014.FT.V12	2014.BUDGET.V00

If I go with the first option that is 3 report per 1 company, then there is no chance of adding multiple companies within a report.

[former_member186338]

Please, explain your requirements for the company selection!

How many companies you want to show? How do you want to select companies?

Vadim

[Former Member]

I'll use company selections with groups of 9 companies without any restrictions. After that, I'll use this report for publish functionality with 4 different company groups which will result in 4 different excels with respect to 4 x 9 =36 different companies.

[former_member186338]

If number of companies is fixed then use static report concept:

Vadim

[Former Member]

Unfortunately, number of companies are not fixed. They will be determined by 4 different company group hierarchies and there can be any number of companies within this group hierarchy max. of 9. Because of this uncertatinty, I can not use EVDRE also.

Do you have another opinion or will I try to handle this with static EVDRE? I prefer EVDRE instead of EPM because of flexibility issues. Please don't get offended.

Also for your topic, if the number of companies are fixed, how can this report can be made? We had EVEXP formerly to get expansions but now, I don't have idea. Mayve VBA. And after that expansion, I can use companies within my static report am I right?

[former_member186338]

I can recommend you only one good idea - just move company dimension from column to row axis and use static column axis with dynamic row axis (containing multiple dimensions including company).

B.R. Vadim