Hi folks, I have a requirement like... for eg:I have a prompts with product category and product sub category... and a horizontal bargraph with prod.category ,prod.subcategory and revenue columns... when user selects prod.category from prompt the graph should show prod.category names on y-axis and then if he choose prod.subcategory then it should show prod.subcategory names on the axis. by default obi displays both the names side by side ,but my requirement is different from this .I need single column names to be displayed on the graph. thanks in advance..
you need to edit the graph properties and select the column which you require in the x/ y axis.
And as mentioned above, use a column selector to change the columns.
Hope this helped/ answered
Thanks for your reply.
But there is a constraint option in prompts.for ex:in 1st prompt if i choose prod.category then prod.subcategory prompt sholud display the values which are related to first prompt value.
we cant achieve this functionality with column selector.
Prompts are used for filtering the report and Column Selector provides the choice of columns which you want to slice the measure by.
If you want to use only one of the column in Y axis at time, you should add column selector.