Data appearance issue when ownership based hierarchy reports are merged

[former_member539392]

Hi Experts,

I've got a data loading issue when ownership based hierarchy reports merged. I have three reports same structure. All of them based on ownership hierarchy.

Suppress empty columns option activated for all reports.

The second and third reports are shared column axis with the first one.

Before merge each report has different count of columns accordingly ownership base hierarchy. When they got merged columns are combined properly.

When I opened a workbook (refresh after opening is activated) the data completely loaded. But when I change TIME in a Context and refresh I've got an empty reports except one of them. Only after second refresh data are loaded fully.

How it looks when I selected different period in TIME context (and than refresh) after workbook opened.

Next step - refresh again and got my data.

Do you have any ideas or suggestions on that issue?

Thanks,

Alex.

[former_member539392]

In case of using of Ownership based hierarchy you need to have dimensions Groups and Entity in the same axis in report editor. You will find that recommendation in EPM Plugin User Guide:

You can display in a report how the group structure has evolved over time. To do so, create a report for the appropriate Category and Time, which displays the dimensions Groups and Entity in the same axis, whether it is the row or column axis. For each Groups member, its main entity is displayed in the cell before or after.

So, I've added dimensions Groups and Entity as you can see on first screenshot of the topic. But I didn't expect that placement of dimensions could affect on it. When I placed Entity dimension above Groups, issue wasn't replicate. Data loaded after first refresh.

Alex.

[former_member186338]

"Before merge each report has different count of columns accordingly ownership base hierarchy. When they got merged columns are combined properly." - not clear... add more details!

[former_member539392]

Hi Vadim,

thank you for your quick answer.

Please find more details below.

Before merge:

As you can see second report hasn't column DO008, DO009 and DO011 cause of suppress empty columns

After merge:

After merge all columns are exist on a main axis

[former_member186338]

What is your EPM SP?

[former_member186338]

P.S. By the way, what is your BPC version? NW or MS? You have used both tags - incorrect!

[former_member539392]

Vadim,

EPM Plug-in for Microsoft Office

SAP Business Objects Planning and Consolidation NW v 10.1 (Standard).

Looks like I had a mistake with tags. I know you hate it. Sorry:)

BTW, seems I've solved my issue. And I assume it was EPM functionality bug.

[former_member186338]

"Looks like I had a mistake with tags. I know you hate it. Sorry:)" - then correct it without moderator alert!

"BTW, seems I've solved my issue. And I assume it was EPM functionality bug." - it's better to explain how!

[former_member539392]

I'll explain it when we finally stop discussing tags.

[former_member186338]

To make it 100% correct the primary tag has to be:

SAP Analysis for Microsoft Office

and extra secondary:

EPM Add-In for Excel

P.S. The question with the final comment: "I solved it" looks strange 🙂

[former_member539392]

Thanks for advice, I will use these tags for future.

I'm writing an explanation right now.