I have Built my first cube and I am looking for sales data at AWM's cube viewer.
I can drill down a hierarchy, but I cannot get any sales data at the cube, the cube was created on the product dimension(W_PRODUCT_D,W_PRODUCT_DH)s,Time (W_DAY_D) and sales fact.
Defined levels are ...
Product : All_Prod,SBU,Category,Sub Category
Time : All, Year, Qtr,Month
measures :Stored measures(Sales_val)
I am using Analytic Workspace Manager Version 220.127.116.11.0.
Does the AWM cube viewer shown data without any caleculated measure?
Can anyone help me ? pls
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.
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