Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
see this
Perhaps this discussion helps: Tutorial - Using Common Date Dimensions and Shared Calendars
Can you share a sample with the requirement of what is the exact need functionality wise?
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
! !
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
See if the attached is doing what you wanted
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
Same difference. Just pretend the table is two separate tables.