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

Bex Doubts:

Hi All,

1. What is NoDIV0? When use it? example?

2. What is NoDIM? When use it? example?

3. When I try to open an old qry, it says : "some objects are not found during the last server access" . press Repair button to resolve or Cancel button.what it means?

4. "Grade-Div" structure is reusable? Do you really want to change Changes really effect other queries(Yes/No).what it means?

Thanks in advance.

Cheers,

sri

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 18, 2006 at 10:01 AM

    Nodiv0 is used to avoid display error in a query when divede a number by zero.

    Nodim is used to suppress currency or unit of misure display; it is usefull if you have to summarize different unit to have a total; otherwise bex display *.

    If you remove characteristics from a cube, when you open the query it will display the massage you said; pressing repair it will remove this char. from the query.

    If you use a structure in a query (Grade-Div), when you doble click on it it give you this message because this structure could be used in other query; chainging it will change also the other query.

    Hope it helps.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2006 at 10:22 AM

    Hi,

    1) NoDIV0 -> as thename suggest..

    example: in your formula..you have written

    = AMount/Quantity

    Consider if Quantity is zero..and you run the query..it will show 'X'..that cell..means divide by zero error.

    So to avoid this ..we use

    like this

    = NoDIV0(AMOUNT/Qauntity)

    2) NoDim-> No Dimsension.

    Example: in your query you have Amount in Group Currency and Local Currnecy as KF in Two Column and you want to sum them in third column as 'TOTAL' (irrespective of changing the LC currency in GC ).

    So, if you do it without using NoDIM..it will show '*' value in Query display at all cell..where GC and LC are different.

    USage: = NOdim(GC) +NODIM(LC)

    3) When you make change like removing some infoobjects and adding some IO in BW backend ..either in ods or cube..and but your still query using those object.

    Then normally ..you get this error.

    Solution: go to Rsrt and in menu-> envri->delete old abap's and generate queries.

    4) When you enter tenchinal name for a structure it becomes global.

    For example:

    Report1 have layout like this->

    -


    Quarter1-- -Last Quarter2 -Last Yr Same Quarter

    Material

    So, you make a structure for your first report.

    Now Say ..report2 ahve same layout like this->

    -


    Quarter1-- -Last Quarter2 -Last Yr Same Quarter

    Funct Area

    Then..you know that you can use the same struture used in report1.So you make the structire1 as global by giving a Technical name.

    So that report2 can use the same structure.

    hope i cleared your doubts.

    Regards,

    San!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2006 at 12:15 PM

    HI San and Polo,

    I am very thankful about your replies.

    With examples its very clear to me.

    And please clarify one more:

    In querey column Captions:for example

    QtyIssued---$'s Issued are fomula's

    displyed captions as

    Qty----$'s

    Why these 2 formulas text are not displayed with full text like QtyIssued---$'s Issued?

    I checked in properties of the KF all settings are "Not defined".

    Pls advise me..

    THanks in advance.

    Cheers,

    Sri

    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.