BIDS MDX Query opening in Design Mode

Question

Hi,

I have an rdl file uses custom MDX to generate a dataset.

The file is opening in Design MOde and removing the custom mdx.

How do I stop it from opening in Design Mode?

Many THanks, S

Answer 1

Strange, it should 'remember' it is custom MDX and open it in custom MDX mode, so you see the written query as opposed to the drag&drop query designer.

I have had something like this happen before, it turned out to be down to a problem with either source control, or some small (Manual) change to the RDL's code - We ended up reverting to an earlier version and all was well.

Any of these apply? Have you tried creating a new report, giving it custom MDX, then reopening it? Do it as a new project, without source control, and it should be fine.

Answer 2

How are you adding the custom MDX? If your manually updating the xml then I've found there are two places where the MDX needs to be placed.

The first is in the Query/CommandText element and the second is the Query/rd:DesignerState/QueryDefinition/Query/Statement

These two need to be the same.

Answer 3

Hi

I'm having the same problem.

I have a report with multiple Data\Set (custom MDX Statement).

The report is correctly generated in the browser mode and on the report server when deployed. the problem is cannot view anymore the MDX statement in the data tab event thought the MDX query still exist in the XML code of report.

Take into consideration that other report created in the same way in the same solution don't have this problem.

Does any one have a solution for this problem

Regards, Elie