It's all about the answers!

Ask a question

Is there a dbo.[Time] like table in RQM? (solved)

Zhaolong Li (325) | asked Oct 09 '13, 4:24 p.m.
edited Oct 10 '13, 11:08 a.m.
original question: how to makeup missing dates in a query.
solution: use a outer join between the table which contains data and another table contains only continuous dates.
Problem: how to get a column contains continuous dates in RQM.
Trick: In RQM data model (not in [Business View] which are queries from data model), each folder contains a "Date" data item. Drag a list to see the data, I found this "Date" contains continuous date from 12/31/99 to 12/31/55 (1999 to 2055 I guess). Add another query from this data item(and filter), then problem solved.
Note: the date item located at the leaf of the tree. It is something like [FOLDER].[Date].[Date].[Date].[Date]. I'm not familiar with these raw data yet. Need some time to look into it.

One answer

permanent link
Zhaolong Li (325) | answered Oct 10 '13, 11:10 a.m.
Hope this can help ppl save some time. :)

Your answer

Register or to post your answer.