topic Re: DWH Reporting - Data Glossary? in Active IQ Unified Manager Discussions

DWH Reporting - Data Glossary?

sanadmin_stadtdo — Fri, 24 Nov 2017 08:40:00 GMT

Hello,

I am looking for a detailed description of the data fields in the OCI.
In the "OnCommand Insight 7.3 Documentation Center" under "Data model fact and dimension tables" you can find the sentence:"For explanations of all data elements used in creating reports, see the Data Glossary ". But where can I find this Data Glossary?

A lot of fields are self-explanatory, some others are not. For example, one evaluation by time period is called "Quarter". What is behind this? Is there an average quarterly result here? Or a value at the end of the quarter (31.03., 30.06., 30.09., 31.12.)?

I have searched several times for a description of the data model behind OCI, but never found it.

Thank you.

Best regards

Michael

Re: DWH Reporting - Data Glossary?

hotz — Fri, 24 Nov 2017 09:40:30 GMT

Hello Michael,

You can find the data glossary by cklicking on the Help (?) icon => "Schema Help" => "Database Schema" on the dwh admin portal https://<dwh_server>/dwh.

Or simply: https://<dwh_server>/dwh/faces/docs/frames.xhtml

For the quarter field, you're probably looking at the dwh_capacity.date_dimension or dwh_performance.date_dimension table, where the description for the repQuarter column is: "Indicates whether this date is the first date available for its quarter."

I hope this helps.

Kind regards,

Gerhard

Re: DWH Reporting - Data Glossary?

sanadmin_stadtdo — Tue, 28 Nov 2017 08:07:23 GMT

That's it - thank you very much. I have searched in different guides, obviously not good enough.

Best regards

Michael