When a user pulls up say Jan. 2001, they need to view the pmt date 12 months from that date (Jan. 2002) AND the svc date 18 months out from Jan. 2001.
What would you use, various transformation tables, one table and different views or some other solution.
Forgive me, I know I'm leaving out...
Using MSTR to find number of days from when a subscriber had a service call (date of service) to when the invoice was paid (Invoice Payment Date). The dates are modeled on separate tables in Microstrategy (the modeling battle was fought and lost so it's relatively static now).
I am coming...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.