Cross tab issue in DMR Mode

[mpervez]

Issue with cross tab repot (DMR Model)

Please find the attached document

[Northern_Monkey]

Why don't you put a case statement around the Year so that it returns a default value when null?

[mpervez]

How can I do that ,
Its Dimensionally modeled relational (DMR) package and its has drill option from Year->Quarter->Month->Day->Hour

[Northern_Monkey]

Just from looking at the SQL in the attached document, I'd place the case statement in there, a step prior to building the dims/measures.

[bus_pass_man]

Try looking at my answer to this question, which you posted on the report studio area and seems to be concerned with the same problem.
http://www.cognoise.com/index.php/topic,29399.msg95092.html#msg95092

While you're at it, could you explain to me what you mean by your response to Northern_monkey please.  I'm not sure what you mean.  It might be an additional relevant datum that would need to be considered.

thx



By the way, I think it is a etiquette rule that you ought not to post the same question in multiple locations.

(let me look it up; yep point 4)
http://www.cognoise.com/index.php/topic,24105.msg75293.html#msg75293

oh yeah point 6 might be relevant too.

Hope that helps!
Live long and prosper!