4 Replies Latest reply: May 27, 2013 5:07 AM by K N Yadav RSS

    How to Create a Cube and deploy to BI Publisher

    841358
      Dear all,

      i need to create a cube and deploy to Oracle BI. where can i create a cube & how in oracle and how can i deploy to oracle Oracle BI?
      please help.

      Thanks
      Sathyendra.
        • 1. Re: How to Create a Cube and deploy to BI Publisher
          K N Yadav
          Hi,

          To create a cube follow the below steps;
          1.Expand the folder for the analytic workspace.

          2.Right-click Cubes, then choose Create Cube. The Create Cube dialog box is displayed.

          3.On the General tab, enter a name for the cube and select its dimensions.

          4.On the Aggregation tab, click the Rules subtab and select an aggregation method for each dimension. If the cube uses more than one method, then you may need to specify the order in which the dimensions are aggregated to get the desired results. You can ignore the bottom of the tab, unless you want to exclude a hierarchy from the aggregation.

          5.If you run the advisors after mapping the cube, Oracle OLAP can determine the best partitioning and storage options. However, if you want to define these options yourself, then complete the Partitioning and Storage tabs before creating the cube.

          6.Click Create. The new cube appears as a subfolder under Cubes.

          To import the Essbase cube, select File => Import => from Multi-dimensional. The Import from Multi-dimensional window appears.
          Enter the following values:
          Provider Type: "Essbase";
          Essbase Server: "<name of machine hosting the Essbase server>";
          Username: "<Essbase user>";
          Password: "<Essbase password>"

          Regards,
          Kashi
          • 2. Re: How to Create a Cube and deploy to BI Publisher
            Satya Ranki Reddy
            Hi,

            Refer the below thread.

            How to Design cube in OBIEE


            Hope this help's

            Thanks,
            Satya
            • 3. Re: How to Create a Cube and deploy to BI Publisher
              841358
              Dear all,

              Thank u for your all Replies.

              Regards
              Sathyendra
              • 4. Re: How to Create a Cube and deploy to BI Publisher
                K N Yadav
                Hi,

                Please mark helpful/Correct as applicable to above posts if they are helpful to you.

                Regards,
                Kashi