Skip to Content
0

Row Axis Shared with Input Form on BPC

Aug 22, 2017 at 10:22 AM

49

avatar image
Former Member

Hello,

In the Infocube we have:

The target is to have a report that shows the data aggregated by sku/month, and next to it an input form to fill in the zero months with the monthly average, but giving the chance for user modifications.

We have a default report with SKU_REF on Page Axis (selected the parent id ALL_REF, Member Only), SKU on row axis, and MONTH on column axis. This report shares Row Axis with the input form that is next to it.

And this input form has either SKU_REF on Page Axis (selected the parent id ALL_REF, Member Only), and MONTH on column axis.

On the default report we have a local member with the monthly average.

And on EPMFormattingInputSheet we have a formula (=IF(M29=0,$X29,M29)) to show the original value from the default report, or if it zero, the average.

The final layout is like seems to be ok:

Default report:

Input Form:

Everything looks fine, but the problem is when the user tries to save the data. It fails with error message because SKU_REF is set to a parent id, member only).

If I modify it from the parent id to a generical one (id GEN) it saves the data with SKU_REF = GEN, and duplicates the data for the months that originally had already data.

And if I move SKU_REF from Page Axis to Row Axis (selected the parent id ALL_REF, Base Level), it may save correctly, but the layout would not be ok for the user, because it would could create an inconvinient extra row:

Default report:

Input form:


Could you help, please? Many Thanks!

untitled3.png (5.0 kB)
untitled3.png (3.5 kB)
untitled3.png (3.5 kB)
untitled3.png (3.5 kB)
untitled3.png (2.5 kB)
untitled3.png (2.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Sep 14, 2017 at 02:00 PM
0

Hi,

How about you use a generic SKU_REF on the input form and adjust your formula to show nothing if there already is a value and the average if there is not.

Regards,
Arnold

Share
10 |10000 characters needed characters left characters exceeded