Skip to Content
0
Former Member
Apr 09, 2013 at 10:52 AM

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

15 Views

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

Attachments

webi1.png (54.5 kB)