Cutom Calculated Level Within Dimension Structure

[SQLBI]

Hi,

I'm putting together a cube based on our company's financial statements.

I've structured my data in my DB so that each Ledger code has a Type, Level and Sub Level, based on its position within the statement.

This results in the following structure within my dimension:

Profit and Loss Account ----Type
Income ---- Level
Cost of Sales
Labour Costs

etc

What i want to do is add a new member after Cost of Sales called Gross Profit, based on the calculation

Gross Profit = Income - Cost of Sales

Is this possible and can anyone suggest how i go about it?

Thanks in advance.



Cheers,
Leigh

"Give a man a fish and he can feed himself for a day..."
Give him the means to catch his own fish and he can really annoy his partner by spending all his spare time fishing!

 

[BKhanna]

Add the 'Gross Profit' member to your dimension table in the required position. Add the formula in a Formula column. In the dimension editor enable the 'custom member' advanced option and select 'Use an existing column' and pick the formula column you created.

BK