It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×11,980
×10,946
×145

question asked: Oct 09 '13, 4:24 p.m.
question was seen: 3,902 times
last updated: Oct 10 '13, 11:10 a.m.

Related questions

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

0
Zhaolong Li (3●2●5) | 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

Most liked answers ↑|Newest answers|Oldest answers

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

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.