obiee dashboar prompt

Question

Hi

I have a requirement of hiding particular column from the report based on the dashboard prompt.

Eg there are 2 categories for cloth type prompt let 1. male

2. female

if I click Male it should only show the column of male clothes

and similarly if i choose female in the drop down it should show me the value of female dresses.

I have tried using presentation variable
but it is showing error
Is there any other approach,,,,

Regards
Bishnu

3018071 · Answer

ohh you mean i have to create a hierarchy???

then it will work fine??

lemme try it

[Deleted User] · Answer

So as I assumed in my reply no need for any variables at all. Your first table just becomes the dimension with "Gender" being the one level above "Clothes_Type" and everything will just work peachy with standard functionality, no coding, no variables.

3018071 · Answer

Thanks Chorachy,Christian

But it seems i am not properly describing the issue

let there are 2 columns in a table

1.Table                                                2.Table

gender    clothes_type                                cloth type      unit price

male       shirt

pant

jeans

female     skirt

top

saree

now the requirement is like i have to create 2 prompts 1.gender

2.cloths type

when i click gender as male it should show only the 3 values for men clothes type in the prompt drop down.

and i can also be able to chose from those clothes type.

the output will be unit_price for clothes_type

Regards.

Bishnu