Common calender

[#1]

Hi,

I want to create common calender for my QV app. Acually I have an app in that there are 4 dimension tables and 1 fact table. So different date fields are there

for analysing each KPI's. So Can i get any tips on creating common calender. Please suggest.

Regards

Suneela

[kaushiknsolanki]

Hi,

     Would you please share those tables with their field names, this will help us to think about solution.

Regards,

Kaushik Solanki

[#3]

There is 1 dimension table and 1 fact table:

1)StartTime and FinishTime - Dimension table field

2)ScheduledStartTime and ScheduledFinishTime and Audit_timestamp -  Fact table fields

I have 20111 and 2012 date and time.

[kaushiknsolanki]

Could you please describe what generally you want to do by linking them all to one calendar.

Regards,

Kaushik Solanki

[#5]

Hi,

I have some KPI's to calculate and analyse with respected fields.

For exp:

1)I have to calculate a KPI which involves AuditTimeStamp field only- This one i want to analyse by this field only.

2)Other KPI by schedulestart and finish time of dimension table.

3)Next KPI by start and finish time of dimension table.

Now to analyse I am using separe fields for respective KPI's. So now I want to link altogether and analyse with single filed(By common calender).

KPI 1, KPI 2, KPI 3-Currently showing in different sheets as these are not dependent on each other. So want to show in single sheet with single filed So that

it can filter accordingle.

As I am not getting how to link by extracting each fileds and manipulate please suggest.

[kaushiknsolanki]

Will you send sample data with few records say aroung 100

Regards,

Kaushik Solanki