Skip to Content
author's profile photo Former Member
0
Former Member

Creating indices for InfoCube and ODS

Posted on Jan 06, 2007 at 06:50 AM 15 Views

How to create indices for InfoCube and ODS

Hi -

I have been trying to search forum to get the answer of this question. What I read was little confusing to me, please confirm/correct my understanding.

For InfoCubes:

We can not create any indices on any particular characteristic. Bw provides indices for us. We can check the functionality of indices iin Performance tab in Manage window of InfoCube. If this is the case, how can we use indices to increase the performance, I mean there is nothing we do to create indices (on any particular filed) right?

For ODS:

Go to change, and under Indices, we can create 010, 020 etc. I created one, 010 and trying to drop one key element but it does not go there? Is this is how one should create indices for ODS, am I doing something wrong?

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 06, 2007 at 07:31 AM
    0

    Hi,

    In case of cubes:

    There is nothing we do to create indices (on any particular filed) . And also there nothing to increase the performance by creating extra indices. Infact it is better tot hink about other performance improvement concets like Aggregates,Cache...

    In case of ODS:

    We Can create our own indexes called Secondary index. And to creation it ,enter in to ODS with change mode, and drag and drop required Keyfields/datafields to your index . only We can take the Info objects which are either part of Keyfields or datfields of the ODS as the part of Index on that ODS.

    With rgds,

    Anil Kumar Sharma .P

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Jan 11, 2007 at 06:00 AM

      Hi PUNZU

      This program is used to delete and recreate index of BW ODS active data table The program will normally be used in a Process chain as ABAP process

      *& Report ZIFBW_ODS_REFRESH_INDEX

      REPORT ZIFBW_ODS_REFRESH_INDEX.

      Data: l_error type RS_BOOL.

      PARAMETERS: P_ODS TYPE RSDODSOBJECT , "Name of the ODS Object

      P_MODE. "Call mode of program

      CASE P_MODE.

      WHEN 'D'.

      • DELETE INDEX OF ODS OBJECT

      CALL FUNCTION 'RSSM_PROCESS_ODS_DROP_INDEXES'

      EXPORTING

      I_ODS = P_ODS

      IMPORTING

      • E_T_MSG =

      E_ERROR = l_error.

      if l_error is initial. .

      message 'Secondary Index dropped for the ODS' type 'S'.

      else.

      message 'Delete Index process failed' type 'E'.

      endif.

      WHEN 'C'.

      • RECREATE INDEXES OF ODS OBJECT

      CALL FUNCTION 'RSSM_PROCESS_ODS_CREA_INDEXES'

      EXPORTING

      I_ODS = P_ODS

      IMPORTING

      • E_T_MSG =

      E_ERROR = l_error.

      if l_error is initial. .

      message 'Secondary Index created for the ODS' type 'S'.

      else.

      message 'Create Index process failed' type 'E'.

      endif.

      ENDCASE.

      Note:

      Execute the report and pass the ODS name and P_mode = ‘C’ & ‘D’.

      C = create and D = delete. And create variants.

      Hope it helps

      ASSIGN POINTS IF USEFULL

      Regards

      CK

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.