Entries missing in report (Data misssing)

[Former Member]

hi guys,

i have facing very strange error.

in my quey having three selection parameters

1) company code

2) calmonth/year

3) vendor no(mandory field)

when ever i enter the 0calmonth/year 2/2006

vendor > 0.

then excute it will come correct data like x , y ,z data comes.

when ever i entere the 0calmonth/year 01/2006 to 12/2006

vendor > 0.

then excute some entries missing like 'y' missing.

what is the problem. plz let me know

if you have any ideas on that.

regards,

Murali

[Former Member]

Murali

The condition Top % 100 will sort the columns of the key figure by the highest value to the lowest in the query result and does not impact the data at all.

It could be the variable and the way it is defined, might change the data.

Check the variable range, if it is defined as ' greater than' or 'less than' or 'gt or equal to and lt or eq' etc. in which case, the data will change accordingly.

Run the query with another variable and check the data, you will be able to identify the issue.

[Former Member]

thanks ramesh for kind information.

in variable i have given only ocalmont/year = 01/2006 to 12/2006

vendor >= 0.

then only i am getting missing data.

in variable i have given only ocalmont/year = 02/2006 to 02/2006

vendor >= 0.

then only i am getting what i missed data.

plz let me know is there any your ideas

regards,

Murali

[former_member184494]

murali,

We have also observed some cumulation issues when using an interval... instead - use multiple single values and then it should come out all right...

Arun

[Former Member]

thanks reply,

and also here they are using conditions like we have selected one key figure , top % 100 values.

is there any conditions issues.

plz let me know.

Regards,

Murali

[Former Member]

Hi Murali,

The discrepancies are because of connditions only , remove the conditions for time being and it should work as per expected.

Hope that helps.

Regards

Mr Kapadia

<removed>

[Former Member]

I saw something like this a long time ago. It turned out that the indexes on the InfoCube had gotten corrupted. After they were regenerated (RSA1 --> right-click on InfoProvider --> Manage --> click on Performance tab --> Check Indexes --> if red, click on "Repair Indexes (Immediately)" or "Create index (Batch)"), everything was back to normal.

Hope this helps...

Bob