Hello,

I published report model based on analysis services database. Everyting
looks fine, except that if dimension is joined to measure group not at the
lowest level, then this dimension does not work.
I have date dimension that for some measure groups is at day level and for
others and month level. And I cannot build reports using date dimenion based
on month level measure groups.
Anyone can help me here?

Thanks

Hi Vimas,

Thank you for posting here!

I notice that you have posted the same question in our reportingservices
newsgroup, to which I have already responded. Please check my answer there,
and if you need any further assistance on this particular issue please
reply to me in that thread so I can follow up with you. In the future,
please don't cross-post the same question in multiple newsgroups. This
will help our engineers work on your question more efficiently. Your
understanding and cooperation is appreciated.

For your convenience, I have included my reply as follows:

------------------

Hi Vimas,

Thank you for using MSDN Managed Newsgroup Support.

Have you got any error message when you want to create the report?

I would like to get the project from you to troubleshot. You may zip the
folder and send to me directly. I understand the information may be
sensitive to you, my direct email address is weilu (AT) ONLINE (DOT) microsoft.com (
Please remove ONLINE when you send the email ), you may send the file to me
directly and I will keep it secure.

------------------

Thank you and have a nice day!

Hi Vimas,

Thank you for using MSDN Managed Newsgroup Support.

Have you got any error message when you want to create the report?

I would like to get the project from you to troubleshot. You may zip the
folder and send to me directly. I understand the information may be
sensitive to you, my direct email address is weilu (AT) ONLINE (DOT) microsoft.com (
Please remove ONLINE when you send the email ), you may send the file to me
directly and I will keep it secure.