Report Formating

building reports desktopintelligence
1

—KRI
Unit–>RISK------
—Control
From Unit–Risk(1 to Many Relationship(1,n–1,1))
From Risk–KRI(1 to Many Relationship(1,n–1,1))
From Risk–Control(1 to Many Relationship(1,n–1,1))

In my universe I have following structure.
Each unit can have 1 or more risk , Each RISK is associated with one unit.
Each risk has one or more controls
Each risk has one or more kri’s
Relationship b/w tables is build as shown in the diagram.
My problem is when I am generating report on unit ,Risk, Control & Kri. Data is getting repeated.

For each control, kri data is getting repeated or vice versa.

I have created 2 contexts
one is b/w unit, risk & control,
second b/w unit, risk & kri

I have generated report. Now Data is not getting repeated, but it is displaying in 2 tables.
Like ( unit, risk, control in one table &&&& unit, risk , kri in second table)

Now I want to display in only one table, but when I am trying kri or control in other tables…it is not allowing to do so. Please help me to format this problem. Or any other way i can do it.
[/img]

gopalbr (BOB member since 2004-05-27)

2

You can display common dimension in two queris PLUS all non-matching dimensions from any one query.
You can not show non-matching dimensions from both the queries in a single table.

All your common dimensions will be coming from Risk and Unit table.
(BTW, are there any common dimensions in the two blocks? If No, you can combine the data.)
Apart from the dimensions from Risk and Unit, you can combine dimensions either from KRI or from Control. You can’t have dimensions from both KRI and Control in a single block.

If you insist to show them in a single block, you have convert dimensions from one of these tables to details.

mkumar (BOB member since 2002-08-26)