Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2003

    Browsing SQL OLAP Cube in OWC Pivot Table using specific levels in dimension

    Is there a way to enable users to view data by a specific level in a dimension (and not the parent levels as well) when the dimension is either a column or row field?

    Let me explain in more detail:

    eg. Time dimension has a typical time hierarchy -
    Year, Half Year, Quarter, Month.
    This dimension was set up in Analysis Manager as a regular dimension and all levels are set to 'regular' type.

    I have set up OWC on our web server for clients to view the cube over the intranet.

    I want them to be able to view data by specific levels when they drag the dimension as a column field (or row) - and not have the pivot table bring in the other levels along with the dimension. So if User X wants to see data at the Month level then:

    Month| Turnover |Costs
    Jan| $1234|$987
    Feb| $2345| $98
    March|$204| $77

    And not what Pivot Table is currently doing:

    Year|Half Year|Quarter|Month|Turnover|Costs
    2003|1st Half|Q4|Jan|$1234|987

    What are my options? Thanks in advance.

    Ann Y.
    Last edited by MiWeb; 10-01-03 at 00:15.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts