No overall result

[Former Member]

Hello,

My question is based on this scenario:

1.I created a key figure as unit price, also a characteristic say material was created and I put the key figure unit price as a display attribute of material.

2.Designed a cube which includes material and key figure quantity

3.Design a query, put material into row, put quantity into column, and created a revenue by using a formula variable to calculate the revenue value(quantity*unit price), I put it into row.

The final result was: I could see the data of revenue in each row, but it didn't show me the overall result, only red 'X'. How can I solve this problem?

Thanks advanced

[udayabhanupattabhiram_cha]

Hi Ryan:

I am sorry I did not understand your question correctly.

When I read it again, you say that the Multiplication is correct and you can see the revenue value(quantity*unit price). What you say is that you cannot see the overall results - Subtotals by Material.

Is this the problem?

If it is, whatever Characteristic you want to sub-total, go to properties and in the Suppress Result Box, select NEVER

You can do the same for time characteristics.

Now, go the Calculated Key Figure - Revenue one and play with the Box called - Calculate Result as. You will find something there.

If its urgent, send me the data & screen shot of query and I will look into it.

Ram Chamarthy

Message was edited by: Ram Chamarthy

[udayabhanupattabhiram_cha]

Hi Ryan:

I saw some good replies in your other post.

Did you try removing the Dimensions first before the Multiplication.

Use NODIM for the Key Figure.

Ram Chamarthy.

[Former Member]

Hi Ram,

yes, I did use the NoDIM function, any other idea?

thanks

ryan

[udayabhanupattabhiram_cha]

Hi Ryan,

You cannot use a display attribute (the key figure that you have) for calculation directly.

But, there is a work around for that.

In query, you have the Characteristic.

GO to the Columns, right click on Key Figures. Choose New Formula.

In new window, in Operands, right click on Formula Variables. Select New Variable.

Here, choose Replacement Path.

Next screen, choose the Characteristic.

Next screen, choose the Key Figure Attribute.

From here, you know what to do, create a new Calculated Key Figure. You will see the new variable that you created before and the Real Key Figure.

Is this what you are looking for?

Ram Chamarthy.

[Former Member]

Thanks!

I know the procedures. I could see the value of revenue which is the calculated KF. My question is why I couldn't see the overall result of revenue which is the cal. KF

[former_member188325]

HI,

Try by setting Calculate result as 'summation' for revenue in properties.

thnaks

[Former Member]

Hi Murali,

I have tried what u told me, but still

Thanks

Ryan

[former_member188325]

hi,

do u see * for any individual values of revenue?

[former_member188325]

Hi,

try this out.

create 2 new formulas

F1= NODIM(Quantity)

F2 = NODIM(Price)

Revenue = F1*F2.

(hide original Quantity and Price )

thanks