• If you have any idea on adhoc reporting please share with me.

    Here are my questions -

    1) End users can create their own reports on the fly using some predefined elements in adhoc reporting.

    2) the current state which is existing is not supported by SSDT when we move to Sql 2012.so we planned to create a tabular model with all tables and views.

    3) I have created the model and deployed to SSAS. We are giving report builder 3.0 to the users and the model

    If users want to create reports will they have to learn DAX language?

    4) Becoz the end users may not know right? Is their any option to drag and drop tabular model to report builder with out writing DAX queries?

    5) And also I observed that in report builder 3.0 there is no icon for desiging mdx querys in query designer window its their in Sql server data tools.