Skip to Content
avatar image
Former Member

Remove 'Not assigned'

Hello All,

In my Bex query, fields which have no data are displayed as 'Not assigned'. How can I remove 'Not assigned' so the field is displayed empty?

Many thanks,

Nick.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 17, 2007 at 12:26 PM

    Hi,

    Just select the field,go to Properties(context menu).

    Select "Not assigned"-- >Context menu ->(select)Exclude from selection.

    Now Execute the query.

    So all the data having "Not assigned " value will not display.

    Hope this helps.

    Regards,

    Tulasi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I am not sure whether your problem has been solved or not, but I have a solution for this issue. In your Bex query designer 7.0 go to query properties and select Value display tab..ther you can set a property called Zero Value display...Zero as space...this worked for me.

      Regards,

      Nagesh.

  • avatar image
    Former Member
    Aug 22, 2007 at 02:36 PM

    Hi,

    I've included the following javascript code in the web template to get around this. Obviously this will only work if you are displaying the reports using Web Analyzer. This is mainly for the values in the table. You might need to modify the code slightly to include drop-downs as well.

    <!-- script to replace blank data in BW with space -->

    <SCRIPT>

    window.onload=Init

    function Init()

    {

    var Elements=document.getElementsByTagName('TD');

    for(var i=0;i<Elements.length;i++)

    {

    var str=Elements.innerText;

    var found=str.search(/Not assigned/)

    if ((found >=0 || str=='#') && str.length<50)

    {

    Elements.innerHTML =' '

    }

    }

    Elements=null

    }

    </SCRIPT>

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Kenneth Murray

      Hi there,

      I appreciate your post on this topic and implementedd your suggetion with WAD 7.01 and created a script element with the jscript the assigned in template z0analysis_pattern that we have assigned as the default for webanalyzer.

      I restarted the cluster server and still no luck. A charachteristic that has no value still shows as # Unassigned.

      Any ideas?

      Thanks

      Lee Lewis

  • avatar image
    Former Member
    Aug 22, 2007 at 02:15 PM

    Hi Nick,

    In the update rules you will have to make a routine or formula that replaces "Initial" values with a dummy value that contains blancs as a description.

    In all charcteristics you will have to add that dummy value.

    But I don't think you want this 😉

    Udo

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 22, 2007 at 02:16 PM

    Hello Nick,

    You can filter those characteristics in query desing by filtering #(not assigned records shown with is character) records. Or you can create a condition to remove # records from rows.

    Sarhan.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 22, 2007 at 02:24 PM

    Hi,

    I think this is not possible except entering (maitaining master data for each IObj with RSDMD) a master data ID with empty key.

    hope this helps...

    Olivier.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 17, 2007 at 03:22 PM

    Nick,

    The way I can think of to change 'unassigned' to something else is:

    In BEx Analyzer Change Query:

    Select the object, right click

    select properties

    In the 'PRoperties of the Selection/Formula' window

    change the 'Description' in the field/dropdown (you may create a new description too)

    That new description will show in the report header in place of unassigned. Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2007 at 08:25 AM

    The best solution i can think of is use the Authorisation Concept and assign the Authorisation value as #. This will solve the issue .

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 12, 2010 at 01:25 PM

    Based on the idea of Lashan Wanigatunga I adapted and refined the script to get empty cells instead of "#" (with 7.0).

    You can copy the if-clause to replace every string you want, too.

    Would like to post it, but i get:

    Method Not Implemented

    POST to /edit.jspa not supported.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi All,

      I got the same issue. Need to display space or NA instead of "Not assigned" or # in BI WAD 7.X.

      Using script or any?

      Any ideas please guide me.

      Thanks,

      KN