I've been looking for references for query subject(metric) calculation in framework manager but have not found any good reference. The reference would
- help in making metrics. eg. metrics to calculate week-to-date sales and year-to-date sales(this year,last year)
- give a list of functions like get the last value of a group for positional data(inventory)
- help in handling multiple fact tables (metrics of both sale & inventory in a row), etc
I need these things both in DMR and relational models.
Actually, I've been feeling difficult to jump start. For instance, to solve the first problem in the list above, first I tried to pull, in the business layer, all rows of my physical sales table of only last two years. Do I need to create query subjects for all columns(24 in my case) and will applying date filter on the DAY_ID will filter the data for all other columns? I am trying to think in terms of row but framework manager drive me to think in terms of individual columns.
Guys need your help!
The first 2 requirements have very different solutions in terms of relational / dimensional model. The third one is very extensively covered in the FM guide and in hundreds of posts on this forum.
So basically, the standard - extensive - documentation covers quite a bit, but you need to specify whether you need solutions for relational vs dimensional model