thank you ,it was helpful

i have a table and a graph in the report.i just want to filter the table not the graph. can i do that using a parameter.

i did that but it is not working

thanks for the reply.i am building publisher reports using rpd subject area.is there any other way to filter

through action link --> navigate to web page

I had to mention that because instead of thinking about the reason for the tool hitting another fact table when we do the count on dimension attribute, you were sticking to the assumption that rpd model might be wrong.

my entire RPD design was inspected by oracle and they did not find any kind of wrong practice in it, I am going to create the counts columns in rpd and ask users not to create any count measures on dimension attributes in answers as it might hit any fact table, unless i specify implicit fact column on each subject area.…

Thanks for the reply. I am using version 12.2.1.0.0. Like you said it is not random table but hits the same table every time i do a count of sku. But my question is why is it generating 2nd set of sql for count of sku instead of doing the count in the same query used for quantity. My concern here is if the user is creating…

thanks for the reply. i want do it in the rpd for adhoc reporting. the above calculation in rpd is wrong?

I tried entering host name and default scheduler port 9511.but i get nqs error 12008 unable to connect to the port . am i missing anything?

i have entered details in below screenshot.i get same error.