Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I want to make a POC for this below data.

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. !Untitled.jpg

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Dear Rehana,

What is your expectation from Community? Work for you or to help you when you get stuck?

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
JyothsnaKundan
Contributor
Contributor

Hi

 

Either help or leave it ,as that you have helped out a lot earlier to him/her.

 

Thanks