Effective December 3, NetApp adopts Microsoft’s Business-to-Customer (B2C) identity management to simplify and provide secure access to NetApp resources.
For accounts that did not pre-register (prior to Dec 3), access to your NetApp data may take up to 1 hour as your legacy NSS ID is synchronized to the new B2C identity.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

DWH Reporting - Data Glossary?

sanadmin_stadtdo

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

1 ACCEPTED SOLUTION

hotz

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

View solution in original post

2 REPLIES 2

hotz

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

View solution in original post

sanadmin_stadtdo

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

 

Best regards

 

Michael

 

 

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public