Whenever we create a modeling view (Attribute View, Analytic View, and Calculation View) and activate it, the runtime column views are created and stored under column view section of _SYS_BIC schema.
The modeling view (for example a calculation view) cannot be accessed directly. We need to call the corresponding column view in _SYS_BIC.
Let us have a closer look.
• Right click on a modeling view and click on Data Preview. Go to Raw tab to see the output.
• Click on the Show Log Button on top right corner and copy the SQL query.
• Paste this SQL query in a SQL editor and let us analyze.
This is actually calling the corresponding runtime object (column view) from _SYS_BIC schema.
No comments:
Post a Comment