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!
- SAP Managed Tags:
Accepted Solutions (0)
Answers (1)
| User | Count |
|---|---|
| 10 | |
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.