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...
This is what the users plan on doing:
Run master rpt,
Drill to separate template for a deeper view,
Use that resultset and surf to another template,
drill again to yet a deeper view.
This process goes deeper for five levels.
This raised the question of "limits" within MSTR on...
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.