Getting star(*) as the value of the column

[Former Member]

Dear All,

i have created a report on the cube which will display the country wise Expected sales Volume and Weighted sales volume.

for all country i am getting the correct value but for the country which are NOT ASSIGNED i am getting Star(*) as the value.

My cube has proper data loaded.

HELP ME ON THIS.

[former_member205352 · Accepted solution]

Just keep the cursor on the * you will be able to see the value on the top in excel.

This happens when you have not maintained unit for key figure or key figure with different units get aggregated.

Hope this helps.

[Former Member · Accepted solution]

Hi praveen,

I didnt get you by "Just keep the cursor on the * you will be able to see the value on the top in excel."

N as per the unit of the key figure is concerned, it is maintained propelry. I am able to see the values for all the country . Only for NOT ASSIGNED i am getting this problem.

Can you further help me on this.

[former_member205352 · Accepted solution]

What I meant is in Excel.

Wherever you see * place the mouse pointer there.

In the top where you can usually see values in excel.You will be able to see values.

or

Right click on the cell -

---

> Format Cells and choose number

You will be able to see

or

Use Nodim() in formula you will be able to see.

The issue is :

Country field unit

A 20 KG

B 30 LB

Now if both A and B country are under hieararchy node NODE1 say

Then on aggregation it will be

NODE1 (20 KG + 30 LB) displayed as *.

When you place your mouse on this cell you will see 50.

Hope this helps.

Edited by: Praveen G on Oct 29, 2008 2:35 AM

[Former Member · Accepted solution]

Praveen,

i am jus draggin objects to the column not applying any formula on it.

when i place the cursor on that * value then its not displayin any value for it, it says "Context menu for * ".

N your concern for different UNITS is taken care of as i have given 0CRM_CURREN as the value for UNIT/CURRENCY for all my key figures.

Hope to receive your futher assistance on it.

[Former Member · Accepted solution]

Pls check the backend data and its currency first to get the real picture.

NODIM will hide ur problem but not solve ur issue.

[former_member205352 · Accepted solution]

Hmm you didnt get what I am trying to tell.It was basic excel.

Anywayz go to transaction RSCUSTV4 and tick the check box Mixed values and save.

Log out and Login in your bex and try.

Hope this helps.

[Former Member · Accepted solution]

Thanks for the answer. My issue is resolved.

Keep responding. i have assigned full points.

[Former Member]

I have maintained 0CRM_CURREN as the value for the UNIT/CURRENCY for my Key Figures.

[former_member465313]

Hi,

You are getting starts as all the values are getting cumulated with different UOM, for different countries. ( If it is amount, then it will be in different currency ) Try to correct why you are getting NOT Assigned value.

Regards,

Ahmed