Question Re: Error occurred in customized bex query in Technology Q&A

Error occurred in customized bex query

Former Member — Mon, 24 Aug 2015 10:58:58 GMT

Hello guys,

I have trouble with a BEx Query in our BW landscape. Error is "Could not find any data to display. This might be due to the current selection of variable or filter values" I have created a query with a lot of key figures but I did not add any filter and variable. When I execute it in BEx (Excel) I did not get data and also I tried to execute it on web portal there is also same error.

Thanks,

Pankaj

Re: Error occurred in customized bex query

Former Member — Mon, 24 Aug 2015 11:05:18 GMT

Hello,

It is not exactly an error but rather the filter values are such that there is no data to display. can you attach a screenshot of the Filter tab in the query designer? It will help ascertain the cause.

Re: Error occurred in customized bex query

sriramvijay_ravidoss — Mon, 24 Aug 2015 11:23:08 GMT

Hi Pankaj,

In the columns, there is no Key figure. Currently it looks like there are charactristics in both rows and columns.

Please drag and drop any valid key figure in columns and check.

-Sriram

Re: Error occurred in customized bex query

RamanKorrapati — Mon, 24 Aug 2015 11:33:46 GMT

Hi,

please check at target level.

All loaded requests at your target have reporting symbol?

Cube/DSo-->manage-->request tab.

Is there any failed requests at target level?

As you said no filter/selections then just remove all key fig from column area.

add one key fig and save the query.

later try run it and see the result.

Thanks

Re: Error occurred in customized bex query

Former Member — Mon, 24 Aug 2015 12:00:45 GMT

Hi,

see this filter tab does not contain any field

Thanks,

Pankaj

Re: Error occurred in customized bex query

Former Member — Mon, 24 Aug 2015 12:03:17 GMT

Hi Sriram,

In column there are key fig but data is not able display.

Thanks,

Pankaj

Re: Error occurred in customized bex query

Former Member — Mon, 24 Aug 2015 12:09:37 GMT

Hi Raman,

Yes that request is available for reporting see this screen shot. and also I have removed all key fig from column area and added one key fig and saved the query but still I'm getting same error.

Thanks,

Pankaj

Re: Error occurred in customized bex query

RamanKorrapati — Mon, 24 Aug 2015 12:23:22 GMT

Hi,

Can you check data at cube level.

Cube-->right click-->display data and see the data.

in above screen shot,a re you able to see any count under added coulumn? (records >0)

Above loaded request is full load or delta load?

Thanks

Re: Error occurred in customized bex query

Former Member — Mon, 24 Aug 2015 13:34:19 GMT

Hi,

36 rec added in target and its delta because its ISU's datasource that data wont come through setup table in source side I run this EBW_DQ_SS then rec populated in delta queue

Thanks,

Pankaj

Re: Error occurred in customized bex query

RamanKorrapati — Mon, 24 Aug 2015 13:42:41 GMT

that's fine. Can you try to see the data at cube level. Cube-->display data--> see the cube data.

Later check data thru Tx - LISTCUBE.

if it displays then something wrong at reporting level.

Can you try to regenerate your report thru Tx - RSRT and see.

if not solved then try to create a one basic report on your cube and see.

Re: Error occurred in customized bex query

Former Member — Mon, 24 Aug 2015 13:53:41 GMT

Hi Raman,

I have checked through LISTCUBE. and also executed in RSRT see this file

Thanks,

Pankaj

Re: Error occurred in customized bex query

RamanKorrapati — Mon, 24 Aug 2015 13:56:43 GMT

Can you create one basic report on your cube and see.

Just use one obejct at respective areas.

like one info char object in Rows(0BPARTNER), one key fig in column.

save and run report.

Re: Error occurred in customized bex query

Former Member — Mon, 24 Aug 2015 17:31:02 GMT

Hi All,

Issue has been solved, actually I was using different cube in query side that cube contains was same required fields but that was coming under obsolete info area (do not use)...

By the way Thanks to everyone for helping me

Regards,

Pankaj

Re: Error occurred in customized bex query

Former Member — Wed, 27 Nov 2019 02:24:04 GMT

Hi Experts,

I am new here and to BW, I need your expertise to resolve this issue.

One of my user facing the same issue. I have checked everything which is discussed above but it did not resolve my issue. Pls help.

My Cube has reporting symbol. LISTCUBE shows all data. I did RSECADMIN, authorization check looks okay to me. the strange part is when I execute same report with my ID it works fine for me but the user is unable to execute the report and the error throws "Could not find any data to display. This might be due to the current selection of variable or filter values".

I am attaching RSECADMIN analysis report here.

I need your expert help on this.

Regards

Ruby