How to Create a TO and FROM date filter using multiple date fields from fact table

[fashid]

Hi Friends,

I have a small application that works as a data extracting tool for users.

This application has multiple fact tables in it .

For the sake of understanding consider I have two fact tables; table A and table B .

There are several date fields in both the tables.

I have used a single date field from table A and a single date field from table B ( based on requirements) and linked them both to the master calendar .

I am using a calendar object that works as a FROM DATE and TO DATE to filter records in both the tables .

Now there is a need that the calendar filtering object should also work on multiple dates from table B.

My question is how do go ahead and solve this requirement.

Should I create multiple calendars for this or something else .

Regards,

Nadeem

[Kushal_Chawda]

see this

Canonical Date

[Gysbert_Wassenaar]

Perhaps this discussion helps: Tutorial - Using Common Date Dimensions and Shared Calendars

[sunny_talwar]

Can you share a sample with the requirement of what is the exact need functionality wise?

[fashid]

Hi Gysbert,

Thanks for your reply.

The post you mentioned deals with date feilds from different tables

I have dates from multiple tables as well as the same table

How would i solve the problem of multiple dates from the same table

Regards

Nadeem

[fashid]

! !

Hi Sunny,

I have attached the sample application.

The user should basically be able to filter on ENQ_DATE or ENQ_STATUS_DATE depending upon his/her requirement .

For example when the user selects the ENQ_DATE then the FROM DATE and TO DATE objects SHOULD FILTER ON THAT COLUMN IN THE TRACKERS and when ENQ_STATUS_DATE is selected in the list box the results should be filtered for that column in the trackers .

Regards,

Nadeem

[sunny_talwar]

See if the attached is doing what you wanted

[fashid]

hi Sunny,

Appreciate your efforts but this is not what i want .

I have updated the application now and attaching it here .

Let me make it more simple.

In the application the JOB_DATE from job_tracker table and ENQ_DATE from enquiry_job_tracker table both are tied to the master calendar as DATE_KEY because the user wants to run the tracker on these dates

Now the user also wants to run the enquiry_job_tracker table with ENQUIRY_STATUS_DATE .

how do i go about doing this

I hope you got my requirement

Regards,

Nadeem

[Gysbert_Wassenaar]

Same difference. Just pretend the table is two separate tables.