Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Outlining the requirement summary as below
• Build the queries to get the data from all dimension and fact tables
• Make sure that for date dimension table get months only the dates that are available in FACT_CPI_SPI table
• Get Project and Program information from Dim_Project table
• Make sure that association of tables are based on dim_date_id and dim_project_id columns
• In sql for fact table alias column name as below
******Fact Table Column Alias******
-------------------------- -----------------
Fact_CPI_SPI_Project CPISPI-Column Name
Fact_Schedule_Status SCHED- Column Name
Fact_Gateway_Status GATE- Column Name
Fact_EPI_Projectwise EPI- Column Name
Fact_Payment_Status PAY- Column Name
FACT_PROJECT_BUDGET BUD- Column Name
• Make sure you have filter in dashboard for
Month Name
Program Name
Project Name
• User then can create their tables and export the data in excel. !
Dear Rehana,
What is your expectation from Community? Work for you or to help you when you get stuck?
Regards,
Kaushik Solanki
Hi
Either help or leave it ,as that you have helped out a lot earlier to him/her.
Thanks