OLAP

Log in to follow, share, and participate in this community.
Filter by tag
  • How to view error logs in awm

    I have just finished building my cube and it failed. How do I view the actual error log for me to be able to know exactly which dimensions are causing issues.  when I use   select * from cube_build_log &nbs...
    1001997
    last modified by 1001997
    How to view error logs in awm

    in OLAP

      Back
    • Optimization steps for Uncompressed cube

      I am new to Oracle OLAP, I have designed a cube with 4 dimensions and three measures. Since I have measures like count of staff and hours encoding, I have to group (sum) # of staff and hours encoded for each team and ...
      1001904
      last modified by 1001904
      Optimization steps for Uncompressed cube

      in OLAP

        Back
      • Data Showing wrong value after 15th digit in Database

        I have two views View-1)xxbi_sales_transactions and View-2)xxbi_sales_transactions_test1 In 'view-1' and 'View-2", thers a column as "Order_number". For view-1 the target table is "wc_sales_trx_lines_fs"-->st...
        Amanullah Khan
        last modified by Amanullah Khan
        Data Showing wrong value after 15th digit in Database

        in OLAP

          Back
        • DBMS_CUBE Execute DML Program in Parallel Over Partitions

          I have a program that populates a cube measure based on previously loaded data. Currently I am passing an argument to the program that limits the Time dimension values being processed. The argument coincides with the ...
          Bronko
          last modified by Bronko
          DBMS_CUBE Execute DML Program in Parallel Over Partitions

          in OLAP

            Back
          • Analytic Workspace Manager possible bug: Maintain Cube hangs

            Hi All, I am a newbe, I have been following the tutorial "Building OLAP 11g Cubes". http://www.oracle.com/technology/obe/olap_cube/buildicubes.htm After the step "Maintain Cube SALES_CUBE", I got the information b...
            740660
            last modified by 740660
            Analytic Workspace Manager possible bug: Maintain Cube hangs

            in OLAP

              Back
            • OLAP_CONDITION in OBIEE

              I am currently running 11.2.0.3 DB with 11g OLAP cubes and have imported them using OBIEE 11g (11.1.1.6.5) Administrator as a Cube based Subject Area. I want to use an OLAP Condition in one of my reports and hence as ...
              Swapan
              last modified by Swapan
              OLAP_CONDITION in OBIEE

              in OLAP

                Back
              • How to reuse one dimension in the same awm cube

                I have created a fact table in the warehouse say Prof_fact . In this fact table I do have 2 foreign keys (fk) say Rnd_fk and Bill_fk. These 2 fk can both be mapped to another dim table called Prov_dim. so basically...
                1001997
                last modified by 1001997
                How to reuse one dimension in the same awm cube

                in OLAP

                  Back
                • not able to get sales data at the AWM - cube

                  Hi, I have Built my first cube and I am looking for sales data at AWM's cube viewer. I can drill down a hierarchy, but I cannot get any sales data at the cube, the cube was created on the product dimension(W_PRO...
                  1010049
                  last modified by 1010049
                  not able to get sales data at the AWM - cube

                  in OLAP

                    Back
                  • Error during OLAP AW UPDATE

                    Hi am using awm11.2.0.1.0 while trying to save a cube am getting the below error The transaction is not committable: "An error has occurred on the server Error class: Express Failure Server error descriptions: DPR...
                    user10303114
                    last modified by user10303114
                    Error during OLAP AW UPDATE

                    in OLAP

                      Back
                    • Error when building cube

                      Hi, I get this error when I am building the cube: XOQ-00703: error executing OLAP DML command "(SYS.AWXML!R11_COMPILE_TIME_DIM('TIME.DIMENSION') : ORA-00600: internal error code, arguments: [xspg: RSALOC02], [],...
                      979482
                      last modified by 979482
                      Error when building cube

                      in OLAP

                        Back
                      • Cube sizing

                        Hi , Is there a OLAP cube sizing template on Exadata?
                        user9134685
                        last modified by user9134685
                        Cube sizing

                        in OLAP

                          Back
                        • Installing AWM

                          Hello to all, I am installing AWM on a machine where 11.2.0.1.0 database is running on RHEL 5.4. I downloaded awm112030A_Standalone.zip . Now running awmrun.sh gives GC warning : Out of Memory! Returning Nil! ...
                          sonidba
                          last modified by sonidba
                          Installing AWM

                          in OLAP

                            Back
                          • AWM    OLAP-DML Expression to large?

                            Preview not available.
                            Schattenzeit
                            last modified by Schattenzeit
                            AWM    OLAP-DML Expression to large?

                            in OLAP

                              Back
                            • How to get OLAP cube objects size info?

                              Hi, I am new at OLAP cube. I want to know OLAP Cube objects size information like VIEW. is any query to get size of Cube objects? Please help me out on this. Thank you, Nitin
                              987709
                              last modified by 987709
                              How to get OLAP cube objects size info?

                              in OLAP

                                Back
                              • Simple truncate all data in a Cube?

                                Hello, this are my first steps in AWM, mostly I tried to manage all over OWB. But know, I want to do simple actions over AW and the OLAP-Packages. I am not lazy, but I don't know where to find simple thinks like tru...
                                Schattenzeit
                                last modified by Schattenzeit
                                Simple truncate all data in a Cube?

                                in OLAP

                                  Back
                                • AWM Adding attributes into a dimension

                                  I have created my SALES cube , and was able to create a report, but now the requirement has changed for the second, its using the same dimensions , but only that I have to add some new attributes in the date dimension...
                                  1001997
                                  last modified by 1001997
                                  AWM Adding attributes into a dimension

                                  in OLAP

                                    Back
                                  • An incoming dimension value is null

                                    I am using AWM 11.2.0.3.0A to maintain a level-based hierarchy. I'm loading from an 11.2.0.3 Oracle database. The maintenance job completes with a warning to check the rejected records log and then an error . When I c...
                                    1001997
                                    last modified by 1001997
                                    An incoming dimension value is null

                                    in OLAP

                                      Back
                                    • Largest Oracle OLAP cube

                                      Forum members, What is the largest Oracle OLAP cube that is out there in terms of total size, number of dimensions, and metrics? The company I recently joined uses Microsoft SSAS for building cubes pulling data fro...
                                      244836
                                      last modified by 244836
                                      Largest Oracle OLAP cube

                                      in OLAP

                                        Back
                                      • Invisible structure in Analytic Workspace Manager after importing from EIF

                                        Hello, I got problem with migration OFA structure (6.3.4) to Oracle OLAP. My Oracle Database is 11.2 Enterprise Edition 1. I've exported OFA database do eif file. 2. I've created user in Oracle database, grant olap...
                                        user56466
                                        last modified by user56466
                                        Invisible structure in Analytic Workspace Manager after importing from EIF

                                        in OLAP

                                          Back
                                        • Create OLAP Dimensions from Multiple Relational Tables

                                          I am using Oracle 11g R2 and trying to create an Oracle OLAP Dimension [using OLAP DML Statements]. I am able to create a dimension with all the levels and attributes define in one single table as source for this dime...
                                          Maverick439
                                          last modified by Maverick439
                                          Create OLAP Dimensions from Multiple Relational Tables

                                          in OLAP

                                            Back

                                          Actions