Skip to Content
avatar image
Former Member

Using hierarchies as Bex Variable (binding issue)

Hello Experts,

I have a situation, and i am looking for a quick solution.

My dashboard design uses simply two combo boxes as an input values for all queries on the dashboard. 1. Year 2. Company code.

Now, since we needed few groups (user requirement) as part of input values in the company code selection combo, we thought to create hierarchies to allow user to select Individual Company Codes aswell as the groups.

It works fine while testing, I took the hierarchy in the combo , dropped the label into a cell, and used a test query to take the combo's value to to filter data.

Now the problem comes when actually we take this hierarchy in the filter pane which has another Filter (year) as well. One of the filter greys out.

I have already tried using prompts in bex characteristics restriction, on the values, and even tried using the prompts in the dashboards, and using one at bex and the other in the dashboard, nothing helped. One of the filters always greys out. But if i take one of them out (any of the two) the other i can bind.

Thanks & Regards

Ahsan Durrani

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jan 05, 2015 at 06:42 AM

    Problem Solved,

    By adding ,DguessDependencies=false  in the Java Child Arguments (CMC>Servers>Dashboards Services>Dashboard Processing Server>right Click Properties)

    thanks

    Add comment
    10|10000 characters needed characters exceeded