cancel
Showing results for 
Search instead for 
Did you mean: 

Query not showing any results - Urgent

Former Member
0 Kudos

Hi all,

I am running a query on the project dates (0PS_C05), although there is data in the cube , the query says no applicable data found, although there is no filter for the object ( Origin - 0DATE_SRCE ) in the query definition , but when the query is run , It is shown as filtered by value 1, can there be any hidden filters.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

possibly there are some restricted keyfigures or conditions on that field. Check this out.

Siggi

Former Member
0 Kudos

Hi ,

Pls check whether query is pre defined with any conditions inside ....

Answers (4)

Answers (4)

Former Member
0 Kudos

Thank you all for your answers.

Former Member
0 Kudos

Hi,

Another way to check is to create a copy of the query. Now on the copied version, simply remove the keyfigures/chars one by one as you execute the query.

One way or the other, you will see the culprit filter in your query...

If helpful, please grant points...

Regards,

--Jkyle

former_member184494
Active Contributor
0 Kudos

Shiva ,

Also check if the reporting status for the request is active . And is this a business content query or something you defined.

Check the query in RSRT and you will find the results / data being accessed.

Arun

Former Member
0 Kudos

Addition to thier checks..

please check if you have any aggregate on top of this..which is not yet rolledup...