convert timescale d-list to datetime dimension.

[Celtic]

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.

[mrobby]

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.

[Celtic]

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)