Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Urgent question about derived non-agg metric
entaroadun, Thanks for responding quickly. I wish that our fact table was built with rolling sums so that calcs could be applied to only one As Of date. However, due to our 2-hr nightly time window for all DW processing, our DW and DM fact tables are updated daily with only the rows...- valinno
- Post #3
- Forum: MicroStrategy, Inc. solutions
-
Urgent question about derived non-agg metric
Hello all, We have need to derive non-agg metric from that generates fiscal month number of latest date ID. We cannot use applysimple Datepart function to extract month number due to fiscal months. Ideally, what method would allow join between FACT table and Lookup table to retrieve fiscal...- valinno
- Thread
- Replies: 3
- Forum: MicroStrategy, Inc. solutions
