nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Hierarchical groups(dimensions) creation in a dynamic cross tab

cocoaparis

Hello,
I'm French so sorry for the English mistakes...
I have a request which returns me the following columns:
USER_ID
OBJET_ID
LEVEL
OBJET_PARENT_ID
PERMISSION_ID

From these data, I want to create a dynamic cross tab:
My lines correspond to the users: USER_ID
My columns correspond to the objects which are hierarchically connected by a relationship between OBJET_ID and OBJET_PARENT_ID
My measure corresponds to the number of permissions: PERMISSION_ID(COUNT)

I obtain my tab with the relationship on two levels:
PARENT1 |PARENT2|ENFANT3
ENFANT1|ENFANT2|ENFANT3|ENFANT4

My problem is situated on the fact that I have relations on more than two levels.
I would like to have a tab which takes into account all these levels.
PARENT1 |PARENT2
ENFANT1|ENFANT2|ENFANT3
|ENFANT4

My column LEVEL represents the level of every object.

I don't know how to do this...

I hope to be clear.
Can somebody help me please?
Thank you for helping.

Find more posts tagged with

Comments

mwilliams

Hi cocoaparis,

I'm not sure if I'm completely understanding. Can you include a small sample of data and what you're expecting your crosstab to look like exactly in both scenarios above? Thanks.

cocoaparis

hi,
thank your for your reply.
I can't join an Excel file so I put what you ask me in a doc file.
The first table is the table I want (more than 2 levels).
The second table is the table I get with BIRT (only two levels).
The third table is the data set I use to get the cross table.
I add the request that I use to get ma data set.

I hope it can help.
Thank you for helping me.

mwilliams

cocoaparis,

Ok, I see exactly what you're looking for now. I don't know that there's gonna be a way to do that, at least with the way the data is set up currently. If there is only a possibility of 3 levels, a column called has children(y/n) and a column called root parent could probably help achieve what you're wanting, but a completely dynamic hierarchy of groups probably isn't possible from just within the designer with no code. Maybe dynamic dataCube and crosstab creation with the API's could do a completely dynamic group setup.

cocoaparis

Ok, thank you.
It's gonna be very difficult for me to resolve it because I don't know the java language but now, because of you, I know that's impossible to do what I want easily.
I'm gonna search a solution

mwilliams

cocoaparis, 
 
Here's a post that may help with the dynamic crosstab creation. It works from a pre-made dataCube, but the code in the beforeFactory should help get you started on making a custom crosstab. 
 
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/1181-dynamic-xtab-creation-using-script/#description'>Dynamic Xtab Creation Using Script - Designs & Code - BIRT Exchange</a> 
 
Another note on making a dynamic cube. You'll probably have to be able to dynamically create computed columns in your dataSet to use as groups in your dataCube.