Disable dragging dimension on Query Studio canvas

[RudiHendrix]

Yesterday I got a new issue from one of the users. He takes an entire dimension and drags it to the QS canvas. So far so good. Then he starts drilling down the dimension. And when he gets to the lowest level the error message: "MQP-ERR-0025 The expression '[Contract].[Contract].[Contract]' is not supported."

If I try to do the same in the sample Great Outdoors Warehouse (analysis) it is just impossible to drag the entire dimension to the QS canvas. That solution would be ok for the end user. However, I don't see a difference in the dimension in my FM opposed to the FM of GO Data Warehouse (analysis).

Where can I set this property of the dimension to change its behaviour?

[vinu]

HI,

I guess we can't drag entire dimension in to QS.

but we can put entire dimension in work area by clicking on 'Insert' button.

Select dimension and Click on 'Insert' button.

Regards,
Venu

[RudiHendrix]

Yes, you are right. However...doing that is the same as selecting the first hierarchy in the dimension and next (with shift pressed) selecting the last hierarchy and drag that to the work area.

What I see here is that actually the dimension is added to the work area. Just one field. That is: in the model that I have created.

[RudiHendrix]

We raised a service request for this item and someone from Cognos had the solution.

This is the response: "Select the datasource in your Framework Manager Model and add 'OL' to the 'Type'>'Interface' property."

And it worked!

Issue closed.