BPC 10 NW/SP15 EPM Add-In - Data Hierarchy aggregation issue

[sharif_shaik]

Dear All,

We are using BPC 10 NW /CPMBPC 801/Level 0005 and EPM Add-In SP15 Patch1 - Experiencing data aggregation issues on some hierarchy intersections and only some months (attached the documents). If I drill down the hierarchy account level, then I can see base accounts underneath that  that hierarchy and balances, but when I collapse the hierarchy, my totals are not correct on one intersection (have 2013.12, 2013.11, 2012.12 time dimension on the column and 2013.12 intersection is not aggregating correctly, whereas the other two are ok). It is very strange and happening only for few account hierarchies.

Any help is highly appreciated.

Thanks

Sharif

Hierarchy Issue.txt.zip

[Former Member · Accepted solution]

Hi Sharif,

Have you tick the check box for calculating parents node?

Andy

[sharif_shaik · Accepted solution]

Hi Andy,

Yes, I tried this....

Thanks

Sharif

[sharif_shaik · Accepted solution]

Hi All,

We have open issue with SAP and they asked us to apply below OSS Notes. Our aggregation issue resolved after applying it.

OSS Notes:

1714492

1753959

1754540

1765218

1766616

1786054

1834939

1835574

1841916

1880673

Thanks

Sharif

[sharif_shaik]

More Information about hierarchy aggregation issue:

1 We built Consolidation environment in our test client - Adding dimensions & members, and imported historical data from flat file uploads.

2. Validated the data by creating EPM reports

3. Transported our environment/structure to our STG client with one member in each dimension.

4. Took the backup of our test environment using UJBR by selecting master data and transactional data options

5. Restore the data in STG client using UJBR by selecting - master data and transactional data

6. Ran same validation reports - some accounts hierarchy aggregation are ok and some are not.

7. We noticed same account - Jan, Feb numbers double at the hierarchy aggregation level and march, april are correct. Time dimension is ok.

8. We used YTD measure for our consolidation model.

9. We built same environment in another client by manually adding master data and importing transaction data, then all reports worked fine - We didn't use UJBR in this scenario.

We open an issue with SAP and waiting for their call.

Thanks

Sharif

[sharif_shaik]

We tested further

Web UI  - There is no aggregation issue if I create report using Web UI

Excel Client - Refresh the worksheet having wrong numbers, but if I select the cell and refresh with selected data, then it works fine.

Also Retrieve function in the excel report generating right numbers.

It seems the EPMolapmembero options are not generating right numbers when we refresh worksheet.

[meenubansal87]

Hi Sharif,

This issue happens with one of my colleague recently and we found that when they were expanding and collapsing the axis, one row axis member was not matching.

So I suggest you please take a look on row axis and column axis while expanding and collapsing.

Regards,

Meenu

[former_member186338]

Hi Sharif,

Can you provide a screenshot, your attached text file is not readable?

Also provide a screenshot of the administration of your TIME dimension.

B.R. Vadim

[sharif_shaik]

Hi Vadim,

[former_member186338]

Sorry,

But you attached an empty file...

Is it so hard to post screenshots?

Vadim

[sharif_shaik]

Hi Vadim,

[former_member186338]

Also impossible to read!

Looks like you don't look on the results of your posts...