Skip to Content
author's profile photo Former Member
Former Member

Getting star(*) as the value of the column

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Oct 29, 2008 at 06:12 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 29, 2008 at 06:25 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 29, 2008 at 06:31 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.