No I don't have. If I have the item_id in the parent report then the count(item_id ) will be wrong as it will group by the item_id too. Any how i can add item_id child report. But along with dimension columns do i need to pass the count column too o the child report.

Ok i got your point. But in my case the parent report columns and the child report columns are from completely different tables. The only link between parent and child report is item_id. so in that case what should be my approach as i cant pass the dimensions to the child report from the parent.

I can apply like that,but it is needed to be joined in the RPD level.else as it is a sum, the value is getting summed up for all the 30 days in the report. I need only the last day's record in my report. apart from that i have one more 'band' column in the output that i am calculating on the basis of this column,so it is…

Hi Joel, OBIEE 11g The no of rows wont extend 2-3 lakhs

Yes I have done that. and in the log it is showing the same error there. the thing is that In UAT it is not showing any error ,only in production the error is there. both config files are similar in structure.

Hi Actually I am applying the between prompt only. But I need only the march months that are coming in the date arange how can i fetch that.

I am new to Unix environment. so facing a bit difficulty

No We are not using any style customizations It is working fine in IE9+ but I am facing problem only in Google chrome..

ok I got this Thomas can you sort the rank column fro here I mean ascending or descending???

how can u apply sorting on the rank and keep rank as dimension like product here. and keep product as a pivot dimension(like product type) here.

Is there any chance that that it depends on browser.. If yes what need to be done and i have tied lot of things nothing is working out.

This is exactly my requirement.. for this did u create a hierarchy for time dimension in the rpd???

Thanks Kavya But if we do like this then only after clicking apply button it will show the month values for the particular year.

Hi, The background error is there because i am applying filters in the criteria part. but I am unable to figure out why the skin customization is not working?? I dont think i is a browser issue

ok I understand Please find the screenshot Here I clicked on table and tried editing the same for formatting.But facing this error. Please help me out.

ohh you mean i have to create a hierarchy??? then it will work fine?? lemme try it

Thanks Chorachy,Christian But it seems i am not properly describing the issue let there are 2 columns in a table 1.Table 2.Table gender clothes_type cloth type unit price male shirt pant jeans female skirt top saree now the requirement is like i have to create 2 prompts 1.gender 2.cloths type when i click gender as male it…

Regards Thomas As both the columns are directly picked from the source table,so no need to apply any rule i guess.| If u can elaborate on your reply,It can be better understood. I am again explaining my query in a better manner.The customer requirement is such that If i click 2010 from the year prompt,than i should see jan…