This content has been marked as final. Show 4 replies
By default, cube viewer shows the default measure of the cube at the topmost levels of all dimensions along their default hierarchies.
You have to use the Selector (Top Left icon, i think) to select a more relevant section (slice) of the cube via dimension selections or for other measures including other stored/calculated measures.
Try to understand how the Selector works... dimensions are available via adrop down, further to dimension selection, you have a dimension-hierarchy drop-down.. Then you can select members at specific level or members which match a condition etc..
Identify a specific row in source table (e.g month_id = 201305 with name= 'MAY-2013', prod_id = 575 with product name = 'ABC Cornflakes', say) and use selector to select the corresponding member (Time dimension .. select hierarchy and select lowest level MONTH, add condition for member matching pattern '%201305' or member name matching '%MAY-2013%' and product dimension.. select hierarchy, then lowest level and then condition for member matching pattern '%_575' or member name like '%ABC Cornflakes%' etc.
Thanks for your reply,
I have find the solution
Thanks & Regards,
I'm new for this Agents concept in OBIEE 11g,
Pls any one help me ...
how to give conditions in new agent creation?
how to add existing action to agent?
is there any option to change colour based on condetion ?(In alerts)
how to use parameters in agents?
Pls send related doc if you have..
Thanks & Regards