Clarity Timesheet Details Location in Data Warehouse
Article ID: 248450
Updated On:
Products
Issue/Introduction
What is the best way to find out what tables are used for certain fields/domains in the data warehouse?
We would like to use PowerBI or some other tool to build reports.
Environment
Release : 16.0.2
Component : Clarity Data Warehouse
Resolution
One way you can find the tables or query needed would be to build an ad-hoc view and then use the option for the View SQL Query
If this option is grayed out your Jaspersoft Administrator should be able to toggle this feature to enable it.
Once you have the query you can modify it for your needs and perhaps just use the query to build your PowerBI report,
There is the DWH Database Schema located at
Table information and the data contained for PPM and DWH
which contains the fields and tables but does not show how to join them.
Feedback
