Skip to Content

Data appearance issue when ownership based hierarchy reports are merged

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.

01.jpg (53.0 kB)
02.jpg (35.5 kB)
03.jpg (347.5 kB)
04.jpg (361.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 23 at 04:25 PM

    "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!

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 24 at 11:20 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded