Incorrect Year data in BO report but right in excel export

Hi,

I do have one report with Year field. When I am looking at data in BO,in some places 2004 is being displayed as 4008, 6012 or 10020 etc. Its not happening in all rows. It is with some rwos. This report is being created using free hand sql.

To verfiy the data i exported the data from Dp and checked in excel and checked the data. Data is correct.

I am not able to udnertsnd the problem…

Any help/suggestion to resolve this issue.

Thanks,
-Manoj


045331 (BOB member since 2004-01-23)

Hi
Did you set the Year object as measure instead of dimension?
I think you should change the Year object to a dimension object and the problem will be solved.

Dennis Siu


LK32 :hong_kong: (BOB member since 2003-12-08)

When you create freehand SQL, all numbers are brought in as measures. BO can’t possibly know which fields are measures and which are dimensions. As was suggested, you simply have to change the right ones to dimensions and you’ll be OK.

When you export to Excel, you are seeing the raw data, not the aggregated report. That’s why it looks different there.


Steve Krandel :us: (BOB member since 2002-06-25)

Thank You Very Much.

Changing the data type from Measure to Dimension solved the problem.


045331 (BOB member since 2004-01-23)