6 Replies Latest reply on Feb 17, 2013 10:30 PM by Ram Prasad

# Calculation with Essbase

I need some help to create view using Essbase Cube. I need to display 2 calculated fields.

1. Difference between sales for current year and last year.

2. Dfference between sales for Actual and Budget.

Year and Scenario are the dimensions.

Along with this we need to create grouping sets for Location Dimensions.

Thanks,

Ram

• ###### 1. Re: Calculation with Essbase

Hi Ram -

Can you describe what you've tried thus far that isn't working? It's unclear whether you're having a problem or you're just looking for pointers on"where to get started"

If it's the latter, check out this quick start guide, and this article about working with cubes

Good luck!

• ###### 2. Re: Calculation with Essbase

Hello,

I tried using Utility Dimension. But that didn't help. Next I tried with Set for Year dimension. Then used Table Calculation(Difference) Using Set. I was able to acheive this. But at the same time was not able to get difference for Actual versus Budget.

For grouping sets, tried with MDX calculated field.

For example [Place].[City_1]+[Place].[City_2], where City_1 and City_2 were members under Place dimension.

Also I have 2 metrics, one for YTD and other for 4 weeks. Is it possible to get these 2 in a single view.

But befor starting with MDX, want to know if MDX is the only solution for all my queries?

Thanks,

Ram

• ###### 3. Re: Calculation with Essbase

You can create sets (collections) of dimension members in Tableau against a cube in the same way you can against an RDMBS. Check out help on how to do this.

Yes, you can get two metrics on a single view. Just add them both to the Columns/Rows shelves.

1 of 1 people found this helpful
• ###### 4. Re: Calculation with Essbase

Russell -

Do you know if it is possible to create a GROUP in Tableau when connected to an Essbase cube?  (example, I would like to combine the values in the dimension field called 'role' into 2 groups: 'professional' (includes values 'professional' and 'executive'), and one called 'production' (includes values of 'hourly' and 'contingent').  The group button appears grayed out to me.

Thx -ng

• ###### 5. Re: Calculation with Essbase

Hi Nicholas -

Nope, no groups against a cube. Maybe a set could stand in for you? Either that, or perhaps your cube developer could add a hierarchy that expresses this for you?

• ###### 6. Re: Calculation with Essbase

Hello Nicholas - Groups is not supported while connected to Essbase. You can achieve same with MDX expressions.