I've created a Parent-Child Hierarchy with Obiee 11g(126.96.36.199).
I can use the filter to select any Root-Node and it can be expanded correctly.But if I choose any intermediate node,it can't be expanded.Then what can I do?
Thanks in advance!
Edited by: Needn on 2011-9-8 下午8:42
This is probalbly caused by the way your filter is set. Remember all the Hieararche Navigation Function are Booleans. So check if the filter logic doesn't restrict the showing of children.
I've checked my filter logic.I use the hierarchy path column with 'STRAT WIHT' logic to match the data as a String.
For example,the Root-Node is 'A' ,its Child-Node called 'A1','A2'...and A1's Child called 'A1B1','A1B2'...
If I choose the 'A' , all the column value start with 'A' will be displayed as a tree structure and all works well ;But it can't be expended when I choose the 'A1' though the 'A1BA' is obviously started with 'A1'.Any advice?Thx
I find a new question is that if I directly choose the 'A1' node without any action before ,then no result will be displayed.
But if I have selected its Parent node such as 'A' before ,then I can see the result when I choose the 'A1' node though it doesn't work correctly.
Thx for your advice,but my qusetion has not been solved.
I don't know how to use these function in the analytics page.Must I modify its default SQL and apply mine?
Its default SQL like the following ,then how can I modify it to achieve my purpose? SELECT s_0, s_1, s_2, s_3, s_4 FROM ( SELECT
*"model"."DIM_PROD_COST_CATEGORY"."CATEGORY_NAME" s_1,* CASE WHEN ISLEAF("model"."DIM_PROD_COST_CATEGORY"."DIM_PROD_COST_CATEGORYDim") THEN 1 ELSE 0 END s_2, IDOF("model"."DIM_PROD_COST_CATEGORY"."DIM_PROD_COST_CATEGORYDim") s_3, PARENT("model"."DIM_PROD_COST_CATEGORY"."DIM_PROD_COST_CATEGORYDim") s_4 FROM "model" WHERE ISROOT("model"."DIM_PROD_COST_CATEGORY"."DIM_PROD_COST_CATEGORYDim")
*) djm ORDER BY 1*