This discussion is archived
1 Reply Latest reply: Aug 9, 2012 11:18 AM by 509179 RSS

Mapping related issues in OLAP

user586345 Newbie
Currently Being Moderated
Hi ,

I am working with Oracle's Analytical Workspace Manager,

Using this tool i have created the dimensions,levels,attributes also provided mappings to it and build it as a cube.

Hence no data has been reflected in the cube from the source DB.

Please, help me out to do this right a way. Also I need to know what are prerequisites for mapping the fields with any source DB to build the cube.



Thanks in advance

Rajan
  • 1. Re: Mapping related issues in OLAP
    509179 Newbie
    Currently Being Moderated
    Being new to OLAP and using the AWM. I made a lot of mistakes.
    One approach that helped me to get through it was to work on one dimension at a time:
    Define a Dimension. Levels. Hierarchies. Attributes. Mappings.
    Then Populate your Dimension (right click on your Dimension name and "Maintain your Dimension")
    If it populates correctly then repeat for your other dimensions.

    Once you are sure your dimensions are ok and populated, then go onto the design of your cube.

    Hope this helps.

Legend

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