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

BW 3.5 - Infospoke - Load Date Selection - not assigned

Hi Folks,

I need to extract from one multiprovider data where load date = current day but also where the load date is not assigned. As I got a cube where load date is empty.

Any ideas how to get the "not assigned" as selection?

Thanks in advance for all replies,

Axel

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jul 04, 2011 at 08:15 AM

    Hi,

    Filter by Load date "Not Equal To" Current date. Then you will get "Not Assigned"

    Regards,

    Suman

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 04, 2011 at 08:20 AM

    hi,

    I need to extract from one multiprovider data where load date = current day but also where the load date is not assigned. As I got a cube where load date is empty.

    The above requirement is nopt feasible as more than one restriction is not allowed in this case as one is a variable which will return current date and other is a value #. You need to find any other identifier in the data set for the above.

    or one of the things which you can do is

    for example if you want the quantity KF for the above restriction then create two RKF's on it instead of one.

    one RKF with Load date = current date

    second RKF with Load date Eq '#'

    create a CKF to add the values of the above two RKF's to use it. that would give you quantity for current date as well as # date.

    hope this helps.

    Arvind.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 05, 2011 at 10:03 AM

    Hi,

    Just put both the filter value as load date ="Current date" in one row and Load date = "#" in the second row(for not assigned) by selecting the row load date and click on the "+" icon which inserts an additional record wherein you can pass the second value.

    I hope you wanted to see the data for both Current date and not assigned right.

    Hope this helps.

    Regards,

    Venkat.S

    Edited by: Venkat S on Jul 5, 2011 12:04 PM

    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.