Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Undesired output - Analysis

Received Response
1
Views
2
Comments
PhongTran
PhongTran Rank 1 - Community Starter
edited Aug 13, 2024 6:16PM in Oracle Analytics Cloud and Server

Hi All,

I have an Answers report, which does not display desired output. The reason being that when I add a new hierarchical dimension, it is totalled up. Please refer to the attachment for details.

Anyone could provide me some pointers how to achieve the desired output.

Thanks,

Phong

Oracle Business Intelligence Product Version 11.1.1.7.1 (Build 130605.1002 64-bit)

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Looks like your "Function" dimension has a granularity modeled in which changes the grain of the query. That's your issue, not necessarily the hierarchy: the actual logical dimension with its keys and level keys.

  • PhongTran
    PhongTran Rank 1 - Community Starter

    Chris,

    Thanks for the promptly response. The Funnction dimension is a ragged level-based hierarchy. The attached Model.docx illustrates how it has been modelled by our BI team. Could you cast your eyes to see if we have missed anything. What I found interesting is that the physical query does not include the lowest level (Function Exp Type). I'm not sure if this makes any differences since both of the summed-up costs have the same function and project's suggorate keys.

    Note: Since I want to use the Function hierarchy as a prompt, I've marked 'Override wth prompt' for "Start with all members' in the Function's selection steps.

    Thanks,