Thanks Gianni. Given the time constraint we were able to deliver the solution with less than 50 MB size of an attachment. We will look into agent logs to get it checked. :)

Thanks Gianni for your response. Yes i meant through email. But we we are getting more than 50 MB file through SMTP server i.e. email but agent is not able to deliver this size. Is there any parameter on scheduler server which might have set a limit on agents?

This is not helping. When D1 is selected it goes to LTS2 and for D1 automatically it selects blank. I have tried following priority group setting for LTS2, LTS1, LTS3 respectively. 1 , 2 , 0 1 , 1 , 0 0, 1 , 0 am i doing anything incorrect.

Additional info: when total count is around i 165k , i dont get this error. However, when total count is around 204k i get this error. And this error coming only for union report.

OBIEE Version : 11.1.1.9.5

Pivot is not option for me as the data is huge. and export in excel doesn't work. I want it in table view only.

Thanks Gianni. Following is the Batch file that helped me to automate the utility. This can be scheduled as per requirement in any environment. REM The temp output location of the CSV output. This will be removed on success set OUTPUT_CSV_TEMP=C:\test\temp_repo.csv REM The final location to copy the CSV output to set…

I got it resolved but now i m stuck with catalog manager report automation. I want a report on analysis and dashboard which shows me what object is placed at which path, which dashboard has what dashboard pages and analysis associated with it. We can do this using create report option in catalog manager. Can we automate…

Thanks Mac2. I have tried the option suggested by you (case statement) but it doesn't work as it shows a blank column i.e. only borders of the column. I am not able to hide these borders. It will be fine if column technically column is not hidden but it should not appear in the reports. Can you please help me with the…

This doesn't help as this approach works only when you have selected direct nodes and their children in the selection steps. I have used groups which are created using direct nodes of hierarchy and saved in the catelog. Thanks.

I am using OBIEEE 11g.