Problem in webi report while pulling measure objects in cross table.

[Former Member]

Hi All,

I have a webi report which displays the plan and actual values for all the months in a given fiscal year for any particular value center.

Universe is created on a SQL table having those fields.

the report supposed to be displayed like the below mentioned figure1.

Instead when i am dragging Actual values, the report is displaying in the below mentioned figure2.

Initial SQL table is

Year	Value Center	Type	Jan	Feb	Mar	Apr	May	Jun	Jul
2013	V1	Plan	10	12	10	10	12	10	20
2013	V1	Actual	8	5	7	3	0	0	0
2013	V2	Plan	10	10	12	10	10	14	12
2013	V2	Actual	5	7	6	4	0	0	0

The table has been pivoted to the below structure.

Year	Value Center	Month Name	Plan	Actual
2013	V1	Jan	10	8
2013	V1	Feb	12	7
2013	V1	Mar	10	5
2013	V1	Apr	10	3
2013	V2	Jan	10	6
2013	V2	Feb	10	5
2013	V2	Mar	12	7
2013	V2	Apr	10	4

The Measures Plan and Actual are aggregated to SUM in the universe.

Unable to find the problem behind the report, why the actual or plan values when dragged into the webi cross table is displaying in the above mentioned figure2. Instead of displaying in a single row, the report is displaying multiple rows.

Any assistance highly appreciated.

Regards

Ram

[former_member184594 · Accepted solution]

Hello Ram,

You need to set Projection Function in Information Design Tool as SUM also. This makes WebI to SUM the values of measure.

[Former Member · Accepted solution]

Hi Zahid,

Yes we did applied sum at Webi Report level, but not working.

We tried at UDT also but required result was not coming.

Regards

Ram

[former_member184594 · Accepted solution]

Hi RAM,

Would you please check the table you are using in your report by right clicking? Make sure that " Avoid duplicate row aggregation" is UNCHECKED.

When it is CHECKED:

When it is NOT CHECKED: