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

For 0CURRENCY : List of values not displayed in selection screen

Hello,

I've 0CURRENCY as part of the query with a user-input variable.

On executing the query, in the selection screen, i do not get a list of valid entries for 0CURRENCY (only USD is displayed). Incase user enters a currency manually. Correct currency conversion takes place.

Any idea why valid list is not being displayed for this 0CURRENCY ?

Regards,

Nagendra.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 20, 2008 at 09:23 AM

    Maybe the characteristic is showing only posted values in cube. It is said in BEX tab of characteristic definition.

    Then if you are loading only USD values you will see only USD in selection screen.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Oscar,

      Thanks for a quick response.

      You are right, my info-provider has only one currency (USD) data being loaded. However user still wants to see other currencies in the list.

      When i check for properties of 0CURRENCY, there are only 2 tabs there : General & Hierarchy. And no where do i find the reference of only loaded data to be shown.

      Where actually do i mention that other values also to be shown.

      Regards,

      Nagendra.

  • author's profile photo Former Member
    Former Member
    Posted on Feb 20, 2008 at 09:24 AM

    Hello,

    Maybe You can try this.

    Click on 0CURRENCY and goto propeties.

    In properties goto the advance tab.

    Here for the second option select values in master data table.

    Regds,

    Shashank

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I checked it, the SID of 0CURRENCY is having all the currencies.

      Where do i tell in the system to show all currencies of master data instead of currencies from info-provider (the infoprovider in this case is having only USD).

      Regards,

      Nagendra.

  • author's profile photo Former Member
    Former Member
    Posted on Mar 04, 2008 at 04:41 AM

    As the valid entry is based upon a varaible of 0CURRENCY which is attached to a key-figure (properties -> currency transalation). Hence the valid entries will not be retrieved from the master data of 0CURRECNY but from the info-provider. As my info-provider is not having all currency (only USD) so just USD is displayed. I suppose this is possible with BI7.0 GUI.

    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.