Filter screen for 0MATERIAL in Analysis doesn't allow to input value directly

[Former Member]

Hi, All!

I have a problem.

Create a query in Query designer. For 0MATERIAL I create a variable with hierarhy allow.

So, in selection screen, when I open a query in Analysis I can choose some hierarhy, or input it:

or input directly material:

And the same in opened query I can add filter to field material in the same way:

But!!! All it in DEV system.

In QUAL and in PROD on selection screen and when query is opened and I try to add filter to material field, the inputbox is gray (input not allowed):

Why?

[Former Member]

Solved my own

To filter data by member within hierarchies | SCN

1256547 - HIER: Checking the hierarchy size

[Former Member]

This message was moderated.

[TammyPowlas]

How were you queries transported to QUAL?  Have you checked?

[Former Member]

Green status. All is Ok.

[TammyPowlas]

Can you filter using Analysis Office with the same query? Or is that the issue? 

If you can't, I would check the BW authorizations in QUAL - use transaction STAUTHTRACE

[Former Member]

Yes, I can filter. I have almost SAP_ALL in qual. 0MATERIAL is not relevant for authorisation chek. The problem is not the authorizations.

Problem: I can't input material or hierarhy directly in inputbox in filter window.

[TammyPowlas]

Is this being run locally in QUAL?  Which deployment method (BI Platform or?) Which version and SP of Design Studio are you using?

You can look at the Design Studio troubleshooting wiki here: Design Studio - Support Page For Client - Business Intelligence (BusinessObjects) - SCN Wiki