http://obiee911.blogspot.com/2012/05/how-to-find-rpd-column-usage-in-bi.html
There was an issue in this export in 10g, i.e. export would sometime insert uneven number of 'Tabs' as seperation for columns. This would mess up when opening the export in excel, as columns would get misaligned and make analysis difficult.
Looks like Oracle has made some fixes to handle this in 11g. I saw option to make export excel compatible:
After using this option, I have so far not faced any issue of misalignment, hopefully the issue is resolved for good!!. This is a big achievement according to me, as it helps us developers as well as business analysits for mapping the columns usage in the reports and dashboards.
The catalog manager report extract provides a list of presentation columns used in the reports, and similar report created from RPD admin tool, can provide mapping from presentation layer all the way to physical column name. This is a big help for Subject Area any clean up excercises or when making a decision on column changes which impacts multiple dashboards.
For your info, I tried this on OBIEE 11.1.1.6.6 version.
No comments:
Post a Comment