Hi all,
I've a Contributor application based on Analyst model. The model has one timescale d-list (Quarters) with periods defined. So i run GTP, then Publish, then created a Framework Manager model using Generate Framework Manager Model Extension. The Generated Framework Manager model does not have any datetime dimensions and the Quarters dimension has only text values. So I cannot use the date-time functions while creating reports based on this model in Reportstudio. Any solutions how can i use datetime functions with dimension created from timescle d-list?
Thanks in advance.
If you were able to include the year in the Qtr Name like "Q1-09" in the planning model then you can open the framework manager model and join a table that would bring in the date to your data. Then add it as another item to the time dimension so its availabe to be used with OLAP functions.
mrobby, thanks for reply.
I've added to query items (start date, end date) in framework model at the quarter's level and hardcoded them. Now i can use datetime functions and filters in reports 8)