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

Reporting / Dashboards off Essbase Cube

Received Response
21
Views
10
Comments
1977947
1977947 Rank 3 - Community Apprentice
edited Aug 13, 2024 7:06PM in Oracle Analytics Cloud and Server

OBIEE 11.1.1.7

Hello,

I would like to create some simple reports off of an Essbase Cube with the following Dimensions

Location
Product
Time

In some reports I only want to use Location and Product dimensions. Must I also include some reference to Time? I am not understanding how to define Non Member or Member in OBIEE.


Thanks In Advance

Answers

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

    I'm not getting your requirement here. Have you worked with either Essbase or Oracle BI before?

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    It can depend on your cube ....

    Sometime you must add at least a filter for the dim your aren't using just because the cube has no data at the gen1 of that dimension. Sometime you just choose what you need and it's enough, no need of any reference to other dims.

    But it's all about how your cube looks like ...

  • 1977947
    1977947 Rank 3 - Community Apprentice

    Thanks Gianni,

    Is there a specific feature that you can enable with the cube so you don't need to references dims that are not used.

    Cheers

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

    That's why I asked whether you have experience with Essbase or OBI - what you're asking has the following response: "Yes that feature is called proper cube construction!"

  • Gianni Ceresa
    Gianni Ceresa Mod

    Well, it's not really a feature, it's called design ...

    Design and build your cube correctly and it's fine.

    If on the other side you have no or little idea of what Essbase is and how it works ... no other option than learn ...

    PS: Christian was quicker...

  • 1977947
    1977947 Rank 3 - Community Apprentice

    Lol. Thanks Christian. This is my first rodeo with Essbase as a source so I guess I'll have to learn it on the fly.

    Cheers

  • Gianni Ceresa
    Gianni Ceresa Mod

    If Essbase for you is just the source and you aren't in charge of building the cube then you have no real option ...

    Try a report and if you have no data start adding filters on dimensions not in the criteria tab, the maximum you can do is ask to the owner of the cube if they can change things (but there can be many impacts, so don't expect a yes as an answer easily ...)

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

    Learning on the fly and facing a beast like Essbase isn't necessarily the most judicious option. Have a look here:

    http://education.oracle.com/pls/web_prod-plq-dad/ou_product_category.getPage?p_cat_id=183

    Cube building is like building a DWH - complex and requiring lots of design reflections before actually doing it.

  • 1977947
    1977947 Rank 3 - Community Apprentice

    Thanks for the link Christian. Luckily for me, the cubes have already been built and for now I just need to consume them in OBIEE. So far, so good.

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

    Well in that case you're dependent on what has been done. Meaning that the cube hasn't been filled nicely in a way which permits analysis you're going to run into problems.