We faced a strange issue last
week ,thought it might help you as well so posting this.
We have a multi-fact model implemented and most calculations on the data are done on BI layer (grouping and summing).
We have a column (say C1) of 255 Varchar as length which when selected in a report used to change the actual numbers. We came across a shortcoming with OBIEE where on the presentation layer BI server was not able to correctly group the data based on C1 which use to add-on OR eliminate few numbers.
Cause: The data field C1 had length specified
as 255 whereas OBIEE server only correctly groups data when it is max of 80
character length.
Mitigation: We used a specific CAST operation
(ex. CAST(C1 as CHAR(255))) and it solved the issue.
This, though a simple resolution, but has
solved a major problem faced by us where the Numbers impacted were the Profit
and Loss figures and had a lot of hue an cry over it, and gave us a learning
about the limitation of OBIEE.
No comments:
Post a Comment