
1. Re: MOLAP Cube: Create Calculations with Dimensions?
. Indumon Oct 23, 2013 12:29 PM (in response to John Maune)Hi John,
While working with MOLAP cubes, you can create Calculated Members with dimensions.
A bit of MDX knowledge is required as a prerequisite
Please find the link below. (Ref: Page 2)
http://downloads.tableausoftware.com/quickstart/featureguides/calcs.pdf

2. Re: MOLAP Cube: Create Calculations with Dimensions?
John Maune Oct 23, 2013 12:32 PM (in response to . Indumon)Thank you for the reply.
Can I used if statements? Can measurements be included in the formula?
Thank you again.

3. Re: MOLAP Cube: Create Calculations with Dimensions?
John Maune Oct 23, 2013 12:37 PM (in response to . Indumon)I looked up MDX. I am not familiar with this. Is there a way other than MDX?
Thank you.

4. Re: MOLAP Cube: Create Calculations with Dimensions?
. Indumon Oct 23, 2013 12:53 PM (in response to John Maune)Another way is add the calculation in the cube itself (back end). I assume you don't have control on the cubes so you have to coordinate with your IT developers team.

5. Re: MOLAP Cube: Create Calculations with Dimensions?
John Maune Oct 23, 2013 1:07 PM (in response to . Indumon)Is there any way I can create a Dimension calculation without needing IT?

6. Re: MOLAP Cube: Create Calculations with Dimensions?
. Indumon Oct 23, 2013 1:16 PM (in response to John Maune)It is pretty difficult to advise you without knowing the exact requirement.
The major challenge with cubes are it will not support data extract creation, otherwise you could have post a packaged workbook with data and we could understand your data structure well.
Please try to explain your exact requirement, so we can at least try for similar MDX codes.
thanks

7. Re: MOLAP Cube: Create Calculations with Dimensions?
John Maune Oct 23, 2013 1:42 PM (in response to . Indumon)So the problems I am trying to fix is this:
Problem 1: I have a dimension, Metal Type, with 6 fields. Example fields are Alloy and Carbon. This dimension is associated with the measurement Tons. I need to be able to show each of the 6 fields on a single report or slice and dice it. With excel, I created a calculation to filter each Metal type and show all on a single report.
Problem 2: If the dimension, Vendor, is Vendor A then use Consume Date else Ship Date for the measurement Tons. I cannot create a IfThenElse statement with dimensions.
I want the Tableau users, like myself, to be able to resolve these issues without using IT. With Excel, I could use a calculated field. With the Cube, dimensions are treated differently. I should add, I open to alternative suggestions. Meaning, if there is a nonCalculated way and IT does not need to be involved, I am all ears.
Thank you for your help,
John.