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

Characteristic value variable not the same in two different cube

Hi

I am using the same characteristic value variable assign using 0CALMONTH for month from and a month to in a query in two different cube. Nothing special are define or restricted but drop down list are not the same from one cube to the other one. One is giving me value starting from 1900 and the other one from 1984.

Any idea.

Regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2010 at 06:44 PM

    Calmonth has to be mm/yyyy. The value the you are referring is YYYY i.e Year.

    can you please check and confirm.

    regards,

    Nirmal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2010 at 12:48 PM

    Hi

    Just to clarify the value showing are 1900/01and 1984/11. Also the properties settings are from infoprovider.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi

      Well here the TOPO. Because i am using a multiprovider with at least two info having in it CALMONTH char define, so my variable is getting the value from the first infoprovider in a sequence that the multiprovider been define.So the first one got value starting from 1900/01...Also my variable was define as taking value from infoprovider.

      Tks all for the help.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2010 at 08:01 PM

    Check the advance tab for characteristic fiscal year. Find the section filter value selection during query execution.

    Hope this helps you.

    Regards,

    Vinay

    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.