I've created a Parent-Child Hierarchy with Obiee 11g(188.8.131.52).
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!
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*