This discussion is archived
1 Reply Latest reply: Nov 23, 2012 10:13 PM by MK RSS

Regarding Logical level key and row wise initialization

RAJ.bi Newbie
Currently Being Moderated
Hi Gurus,

What is the purpose of row wise initialization in external table authentication and when we have to go for row wise initialization.

Why we have to enable logical level key in hierarchy is this only for getting drill down to the next level if we make two columns as logical level key what will happens. If we want to enable a column as a logical level key what are the character sticks that column should satisfy.

Thanks,
  • 1. Re: Regarding Logical level key and row wise initialization
    MK Pro
    Currently Being Moderated
    1) Row Wise Initialization used to hold multiple values in a variable. Let says SQL gives 4 rows (A,B,C,D) as output. Now I want to hold 4 value in a variable to get this happen we need to go for RowwiseIniziation. If you do not do this at any point in time Variable holds only value A not others. Simply it works as Array.

    2) Level keys define the unique elements in each level and provide the context for drill down. You can make two logical columns as logical key but you need to make sure what to be displayed in your hierarchy by selecting DISPLAY. If you make to as separate logical keys and set Display for both you get two columns in the hierarchy

    http://gerardnico.com/wiki/dat/obiee/hierarchy_level_based

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points