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

How to convert Char to Keyfigure in query

Hi guys,

I'm using a characteristic called ZONTIME (On time) for Aging report. This Characteristic holds a positive number, negative number or a zero. This calculation is doen at the DSO/cube level transformation using a field routine. ZONTIME = Clearing Date - Net Due Date.

The positive number indicates that the invoice was cleared x number of days "early"; the negative value indicates that the invoice was cleared x number of days late and zero means that the invoice was cleared 'on time'.

The idea is that I want to use this characteristic in the query and put restrictions on it as following:

Early ZONTIME < 0

On Time ZONTIME = 0

0-15 days 0 < ZONTIME <= 15

Greater than 15 ZONTIME > 15

The issue that I'm running into is that when I try to save this query definition, I get hte following error: "The query has to specify a key figure"

I think the problem is that ZONTIME is defined as a Characteristic in BW. Can someone please help me in getting aroung this error?

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Feb 28, 2013 at 08:42 PM

    Hi,

    You have to use a Formula variable for that. Please search in SCN about it and you'll find plenty of posts.

    Thanks,

    Ranga.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      char can be converted but the values should be convertible. i.e. system can't convert abcd to 1234. This feature is mainly for converting dates to key figures so that dates can be calculated. Or values like 1, 2 3 4...being numbers they are stored in char...so can be converted.

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.