Reg: analyticsRes folder report schedule

Newuser1

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,

[Deleted User]

a) Why analyticsRes? You may have found it on google but apparently not what that folder is used for. It's the standard folder for custom style/skin deployments!

b) https://docs.oracle.com/cd/E28280_01/bi.1111/e22258/add_burst_def.htm#BIPDM344  <--- BIP bursting

Newuser1

Hi Christian,

Thanks for your time.

I have go through the link which you have shared,but our requirement is need to export the report into shared location in excel format that should be accessible for the users.

Thanks,

[Deleted User]

@Raa.BI Cleary you have not gone through the link I shared because otherwise you would have seen that it contains precisely what you want:

https://docs.oracle.com/cd/E28280_01/bi.1111/e22258/add_burst_def.htm#CHEJDGAG

Gianni Ceresa

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 !).

[Deleted User]

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.

Sherry George

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