Reg: analyticsRes folder report schedule

Question

Hi Team,

We have a requirement like report with around 1 million rows * 50 columns need to export this report in excel format in some specific folder.

Folder should be accessible for users, daily report as to export into that folder in excel format need to achieve this in BIP or OBI. On google came to know about analyticsRes folder in OBI how we can schedule report into this folder.

Currently we are using OBIEE 11.1.1.7.1 version can anyone suggest on this.

Thanks in Advance,

Sherry George · Answer

Just a small detail to Christian's suggestion of using BI publisher to send the report to a shared location. You do not need to to write a bursting definition, but just choose ftp as the destination when you schedule the publisher job. You have to setup the ftp server details under Manage BI Publisher -> Delivery

https://docs.oracle.com/cd/E23943_01/bi.1111/e22257/create_rpt_jobs.htm#BIPUG195

[Deleted User] · Answer

Gianni Ceresa wrote: BI Publisher bursting is the less worst one

Why thank you X-D

Clearly in a clever implementation that kind of mass data would not be pushed around this way. But hey we live in an imperfect world.

Gianni Ceresa · Answer

Raa.BI wrote:On google came to know about analyticsRes folder in OBI how we can schedule report into this folder.

Sorry but you google the wrong thing as Christian said ...

AnalyticsRes isn't accessible to users at all, it's a folder on the server, I hardly see how it can be accessible as it's the "shared folder" where OBIEE can access things, not your users (so custom styles, custom javascript libraries). You found the wrong "shared" direction, you want the other one.

So the direction Christian pointed you about BI Publisher bursting is the less worst one (OBIEE isn't a datapump tool, 1 milion rows x 50 columns isn't an analysis or any analytical thing, it's datapump !).