So you just want to dump the raw XML to the screen? If so, then the links provided guide you to being able to do just that ... if you want columnar representation of xml elements that's a different approach.

Are you looking to display the clob contents or have individual columns reflect the content of individual xml elements from within the clob?

use the below to get the pieces in the physical mapping of a logical column ... <span class="kwd" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #101094;">select</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">…

Hence the importance of a properly formed calendar dimension where every date has these types of attribute just laid down and there's no on-the-fly calculating ... very simple in ETL/ELT to do it and then no matter what date a use picks a simple lookup to the dimension returns the desired start, end, and days in between.…

You are better to incorporate your logic into your ETL/ELT, populate a destination table, and then just model the destination table.

Balanced Scorecard is a management approach ... OSSM just allows you to manage measure/metric/KPI relationships and visualize your scorecards from curated data sets according to your implementation of the approach. The visualizations aren't really/strictly 'reports' -- but rather interactive status/relationship diagrams.

What's your initial classification of errors/issues? That drives any intelligent direction you might receive here.

A single company can be in multiple countries ... you need a distinct key for company-country ... the hierarchy keys have to be related ... currently you have no relationship (logically) set for country and company -- data just repeats at the summary level where a 'match' exists. Use of information drives physical/logical…

In your data source you should be able to find occurrences where a dimensional key is not represented in the set of intersections of the other keys. Simple profiling queries are all that's needed.

There's no data point at the intersection of your dimensions ... that's valuable in formation AND different from a 0 (zero) at that intersection. Don't muddy the intelligence displayed. Technically you are changing data at run-time -- HUGE risk.

mmajdana1 wrote:Could not agree more, but this is the requirement, ! I disagree somewhat - it is a request of the tool ... for it to have become a requirement of the tool whomever was vetting wishes didn't know the capabilities and intent of the tool. Another tool is needed ... best bet is dump from database OR live…

Why export? The intent of OBIEE is on-screen interaction with data and decision/action at that point - sounds like you have a goal/requirement that isn't aligned with the purpose of the tool.

Master-Detail ...

A DW without a time/calendar dimension? Say it ain't so ... stop all the OBIEE effort and remedy that up front ... it is the very first step in building a DW. The best way to build a time/calendar dimension is to set it up as a domain sourced (non-system sourced) entity in your DW and set its DW key equivalent to a date…

The user wants a data dump ... satisfy that requirement straight from the database OR use BI Publisher to query the data straight to excel

TOTALLY different products ... I use both in professional dealing with clients' information needs ... PowerBI is built for the analyst OBIEE is built for the enterprise ^ that right there makes ALL the difference in the world. I have run into REAL snags with those who confound the two ... especially when trying to force…

Actually, I know the meaning of Worst Case, for example if an Objective has three (3) KPIs, one with "OK" status and the other two KPIs with "Warning" status, then, the status of the overall Objective will be "Warning". Right? Yes,correct. Also, as I understand, the overall status of the Objective will be "Warning", with…

"it's a requirement" ... yet it's not in keeping with the intent or design of the tool being used ... meet the requirement with the right tool ...

In the documentation where you found the write-up of the assessments, there is links to examples of each method right below it ... Here's a public link to 11g documentation ... https://umetrx.spire.umass.edu/analytics/olh/l_en/scorecard025.htm notice the examples right after the initial write-up. Is your question really…

Make yourself one of these - and distribute it to every user; preferably when they request initial access. The following is a guide - change it to have the most impact for your users ... http://www.oracle.com/technetwork/middleware/bi/documentation/bieqg-1911949.pdf