Ventilate data on the selected entities from different hierarchical levels

[Y.CROZET]

Hello,

The main objective of my project is to burst one report by entity in the Entity hierarchy.

All reports are based on the same essabse cube who included the following Entity hierarchy :

GROUP
  ENTITY 1
    CHILDREN 1
    CHILDREN 2
  ENTITY 2

When I launch one report, Sales 001 in attachment, with the prompt 'ENTITY 1' and 'ENTITY 2', two childrens with the same father 'GROUP', I have the correct expected result.

But when I want launch this same report with the prompt 'ENTITY 1' and his children 'CHILDREN 1', the results are not correct. The report with the prompt 'ENTITY 1' will be the same that the first case of execution. But in the 2nd case, the report brings the lines of 'CHILDREN 1'.

The problem also persists when selecting children from different parents. Only the first case works (Children with the same level and the same father) in busrt mode or in the html mode. So this problem is not linked by the burst process.

Note that this problem is not present in one another report, the P&L 001 report because it's crosstable is not broken over the entity. So the problem comes from the need to ventilate data on the selected entities from different hierarchical levels.

Here are some things we have tried without success:
- Added a pageset over the entity
- Use of details request
- Change data item Children_selected_entities

The selection of multiple entities of different hierarchical levels and in different branches is a prerequisite to customer needs. It is therefore not possible to enter single value prompt over the entity. This is currently blocking, so I want to quickly know the feasibility of our need as well as the solution to establish.

Thanks in advance for your help.

Yohann

[TheFrenchGuy]

Hello there,

pls, can you just add a screen print of what you obtains and what you want ?
Cause I'm not sure to understand all the things.

Ty

[Y.CROZET]

Yes of course, sorry for this oblivion

Case 1 : OK


This is the result of the children 3-1 with the selected prompt on the children 3-1 and 3-2


Case 2 : KO



This is always the result of the children 3-1 with the selected prompt on the entity 3 and his children 3-1
In this second result, all childrens of entity 3 are presents in the children 3-1 result

[TheFrenchGuy]

Hello,

what kind of prompt do you use ? Is it a tree prompt ? cascading prompts ?

Btw you're running report with different dimensions and I think it's the point ... what is the main purpose of your file ?
Burst to the entity for each children selected ?

[Y.CROZET]

Hello,

The entity prompt is a tree view prompt.
I used this data item in my crosstab for the summary part (last line of my crosstab) :
unique(descendants(set([DASHB - Attributes - Unassociated].[Entity].[Entity]->?P_GEN_ENTITY?),0,SELF))

And I used the descendants of the previous expression for the details part as below :
descendants([IT_Entity],1)

Moreover I have a section in this report based on the data item IT_Entity.
The main purpose of this report is to busrt the report for each entities selected and generate one file for each selected entity... but if I am not in the first case (see previously), the file displays inconsistent data as already mentionned.

NB: I don't have this issue with all others reports who not included entity (father or children) in the crosstab but only in section.

Last point but not least, I already opened one PMR to IBM support. But for them, this issue is advanced reporting topic and out of the reach of IBM Cognos Support.

Thanks in advance for your help.
Yohann