REMODELING CUBE IN BI

June 9, 2009

WE NEED TO GO TO TRANSACTION RSA1.

UNDER MODELING WE HAVE ADMINISTRATION.

WE CAN SEE THAT IN SCREENSHOT 1.

CLICK ON ADMINISTRATION.

SCREENSHOT 1

clip_image002

NOW UNDER ADMINISTRATION WE CAN SEE REMODELLING WHICH IS MARKED.WE CAN SEE THAT IN SCREENSHOT 2.

CLICK ON THAT.

SCREENSHOT 2

clip_image004

AFTER CLICKING ON REMODELLING WE GET A POP UP.

WE CAN SEE THAT IN SCREENSHOT 3.

CLICK OK ON THE WARNING.

SCREENSHOT 3

clip_image006

WE CAN SEE IN SCREENSHOT 4.

GIVE THE REMODELING RULE NAME AND THE INFOPROVIDER FROM WERE

YOU WANT TO GET YOUR TARGET (CUBE).

THEN CLICK ON CREATE.A POP UP WILL COME.WE NEE TO GIVE THE DESCRIPTION AND THEN ENTER.

WE CAN SEE IN SCREENSHOT 5.

CLICK ON THE BUTTON WHICH IS MARKED IN RED.

THAT IS CALLED (ADD AN OPERATION TO LIST).

SCREENSHOT 4

clip_image008

SCREENSHOT 5

clip_image010

SCREENSHOT 6

clip_image012

WE CAN SEE IN SCREENSHOT 6.

WE GET A POP UP, IN THAT WE HAVE THE FLEXIBILTY TO

  • ADD CHARACTERISTIC
  • DELETE CHARACTERISTIC
  • REPLACE CHARACTERISTIC
  • ADD KEY FIGURE
  • DELETE KEY FIGURE
  • REPLACE KEY FIGURE

WE CAN SEE IN SCREENSHOT 7

HERE I AM ADDING ZK_REG TO CUBE.

ZK_REG IS A CHARACTER.

WE HAVE TO ASSIGN IT TO A DIMENSION.

SCREENSHOT 7

clip_image014

IF WE TAKE CONSTANT WE WILL BE GETTING FIXED VALUE TO THE FIELD WE ARE ADDING.

HERE ZK_REG (REGION) IS AN EXCLUSIVE ATTRIBUTE OF ZK_CNO.

WE CAN SEE THAT IN SCREENSHOT 8.

SCREENSHOT 8

clip_image016

SCREENSHOT 9

clip_image018

WE CAN SEE IN SCREENSHOT 9.

THE FIELD ZK_REG IS ADDED TO THE CUBE.

THE SAME WAY WE CAN DELTE AND REPLACE CHARACTERISTIC.

Share and Enjoy:
  • Twitter
  • Google Buzz
  • DZone
  • Digg
  • Reddit
  • Diigo
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • LinkedIn
  • Mixx
  • email
  • PDF
  • Add to favorites

tags:
posted in SAP-BI by saikiran

Follow comments via the RSS Feed | Leave a comment | Trackback URL

4 Comments to "REMODELING CUBE IN BI"

  1. vengalrao wrote:

    Goodone

    [Reply]

  2. SAP Jobs wrote:

    Thanks for that, was very nice to work through, helps when the tutorials as so clear and concise!

    [Reply]

  3. Mohammed wrote:

    Fabulous cleared me the concept of Re-modeling rules in SAP BI…..Nice

    [Reply]

  4. Venkat wrote:

    Its very good,keep it up and help the people with your knowledge is always good

    [Reply]

Leave Your Comment

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org