Essbase cube reporting in obiee 11g — Oracle Analytics

Oracle Analytics Cloud and Server

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

Essbase cube reporting in obiee 11g

Received Response
61
Views
11
Comments
Saro
Saro Rank 5 - Community Champion

Hi friends,

Im in obiee 11.1.1.7.1 and integrated with the ESSBASE cube 11.1.2.4 into rpd. Now i can see the cube in the physical layer and after that i converted the Essbase measure column into the flattened measures and moved it to BMM/Presentation layer and deployed it.

Finally while viewing the results in the BI i cannot see the measure value appearing, as i can see only the dimension member values for the cube in bi. Why does the measure values are not appearing and what was the reason for this?

Thanks in advance.

Regards,

Saro

«1

Answers

  • Hi,

    So in your analysis the measures columns are empty?

    Does your cube contain any data?

    Does the point of view you are looking at have some data?

    Often the data in Essbase are "somewhere" else than the place you look at, so double check the point of view, test it with SmartView maybe if you can so you can be sure of what filters to set to get your data.

  • Saro
    Saro Rank 5 - Community Champion

    Dear Gianni,

    Thanks for the reply.

    I performed filtering of the particular dimension members to view the result of the measure. The below is the expected result for measure 1500

    My analysis with the following filters

    The results are only if i compare the dimension attributes

    But if i apply any of the measures to the existing above dimensions, im getting like no results below

    Im not sure particularly which measure to compare, as for as from the excel sheet in the first screenshot you can see the measure column called Amount as 1500, but once after i converted my single essbase measure hierarchy to the flattened measure i can see nearly 200 measures created. And if i compare any of those members in that 200 then it results in no data like the above.

    Does my measure column named Amount will reside inside the 200 flattened measures?

    Thanks,

    Regards,

    Saro

  • Saro
    Saro Rank 5 - Community Champion

    Thanks Gianni. With the right combination i can fetch the results.

    Regards,

    Saro

  • Saro
    Saro Rank 5 - Community Champion

    Hi Gianni,

    I need your suggestion for my query.

    As far as with the essbase result in BI im getting the results for the right combination of data in BI.

    Say for the result to appear i need to give the below no of filters in my analysis

    filter.PNG

    Suppose if i remove any one of the filters from the above, im getting No Results. Incase if i need to see all the values then do i need to specify all the values as a filter in the analysis which is like highly difficult. What could be the possible soln for this issue.

    Thanks in advance.

    Regards,

    Saro

  • Do you always need to set all the filters?

    Don't you maybe just need to set some high level one and then having the column in the analysis is enough to explore your data?

    Other option is to look on the cube side if it can't be designed a bit better for analytical needs.

  • Saro
    Saro Rank 5 - Community Champion

    Dear Gianni,

    Do you always need to set all the filters?

    >>Yes Gianni, as of now to see the data it is asking to set the filters or else it is resulting in No data.

    Don't you maybe just need to set some high level one and then having the column in the analysis is enough to explore your data?

    >> Our expectation is like that in way that, we need to see the results with high level one filters alone instead of specifying all. But in our case it is not happening as it is asking us to specify all the filters combination.

    Other option is to look on the cube side if it can't be designed a bit better for analytical needs.

    >> But in the cube side also it is been designed is such a way that the budget measures can be entered for all the intersection combinations only and it cannot be entered without selecting the combinations as said by our ESSBASE developers.

    Is this issue, needs to be addressed in the cube side or it is a problem in the BI side. As far as from my concern i feel like the problem is with the cube side(As the budget figures cannot be entered without all the right intersection combination of dimensions and because of that BI does expects all the right combination of dimension values in the filters for the data(Results) to be in shown.

    What do you think Gianni?

    Thanks,

    Regards,

    Saro

  • Well, I understand (and agree in part) with your Essbase developers about entering values. But that's why you have calculation scripts (if BSO, if yours is ASO it's supposed to be dynamic, but I guess yours is BSO) to aggregate and propagate data to the upper levels and so you can get data with some high levels filters and then you drill down as you want.

    So is the cube calculated? Doesn't it miss something on that side?

    It make little or no sense to me to just keep the cube as you entered data without doing any calculation as you are not really using it completely (and you could do the same with a DB in the end...).

  • Saro
    Saro Rank 5 - Community Champion

    Thanks for your suggestion Gianni,

    Let me point out this to the ESSBASE developers.

    Regards,

    Saro

  • Saro
    Saro Rank 5 - Community Champion

    Dear Gianni,

    One more quick question, what we are wondering to understand is like how the cube stores the data and how we can view this. Basically we tried to understand this from our ESSBASE developers but their explanation is not much satisfying.

    Generally with the relational data which is sitting on the tables, view etc can be retrieved and seen through several tools like toad, sql developer etc. In that case, how we can see the cube that stores the data with in it. Is there any tools to query the cubes in order to see its data structure like that.

    Thanks,

    Regards,

    Saro

  • Well,

    Essbase store data as  ... in a cube

    You can't really try to find same things as tables, views (which actually doesn't story any data) etc.

    A cube is built using dimensions, each dimension has one or many levels (you can also refer to them as generations: level 0 is the leaf, generation 1 is the root of the dimension and numbering are opposite between the 2 going up / down).

    A cube speaks a language in the same way as your DB speaks SQL, the cube query language is MDX. You can have clients able to send MDX queries to a cube, you can do it by command line installing the essbase client (you are supposed to have it to be able to load a cube in the OBIEE Admin tool).

    You can also use EAS, Essbase Administration Service which is now generally deployed on the web (it's java based). With this tool you can explore the cube outline (the structure, dimensions etc.) and also you have included a window to run MDX queries and view data.

    Essbase is really a big topic, so not easy to answer in few lines, just take it as a kind if DB: so it has structures, data and interfaces / languages to interact with it.