BIDS MDX Query opening in Design Mode

By : Stephen
Source: Stackoverflow.com
Question!

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

By : Stephen


Answers

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

By : Meff


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.



This video can help you solving your question :)
By: admin