Use OBI11 go url to download an entire dashboard in excel format

Yossi Belitsky

HI

I searched the go url syntax (which we are using a lot) trying to find how to download an entire  dashboard in excel format.

Will appreciate an answer with an example.

Thanks

Yossi

Gianni Ceresa

Hi,

Downloading a full dashboard in Excel first requires a special privilege.

The easiest way to find the link you need to use for that is simply to look at what happen when you click on that button in the menu in your OBIEE.

You will find what link to call if any or the JS function to use for it.

Yossi Belitsky

HI Gianni

Thanks for your answer!

I have the privilege to do that -  I do it manually also - But when I do it, I do not see any change in the URL line which I could copy from..

also the "create prompted link" doesn't help here.

So I don't know what are the parameters expected here..

Thanks

Yossi

Christian Berg-0racle

Haven't tried it out right now but isn't is just

&Action=Download&format=excel2007

in the URL?

Ref. https://docs.oracle.com/middleware/12212/biee/BIEIT/apiwebintegrate.htm#BIEIT357

Yossi Belitsky

Thanks, Christian.

But I tried this - doesn't work.

Yossi

Gianni Ceresa

I didn't say it was a link (so a change in the URL in your browser)....

There are more chances it's done by JS, and you don't have a simple link to call for it but need to call a JS function (or at least go through the JS function calls to find out which is exactly executed and what it does).

As said I don't have a 11g around, but on a 12c for example when clicking on the "export entire dashboard to Excel" button this happen:

1) a javascript function is called

saw.dashboard.HandleLayoutClick(

"/shared/SampleApp/_portal/Sample Dashboard",

"Sales Summary",

"entireDashboard",

"excel"

);

2) inside "saw.dashboard.HandleLayoutClick" based on the 3rd parameter another action is executed, another function is called

saw.dashboard.exportToExcel(

"/shared/SampleApp/_portal/Sample Dashboard",

"Sales Summary",

false

);

3) this "saw.dashboard.exportToExcel" function does a bunch of things, it is the one running the download

All these JS functions are into /analytics/res/v-4jW6pbK4mhw/b_mozilla/dashboards/portalscript.js .

Again: this is a 12c instance, so yours may be different, but just by using your browser developer tool extension you will find out all that and analyse the code and the calls to find how you can reproduce that. I'm kind of sure a URL doing that doesn't exist, it's a pure JS thing, but look at the code and find out if you can trigger that in a way or another ...

Yossi Belitsky

Thanks a lot Gianni.

I will try that.

Yossi

Christian Berg-0racle

Ok so Gianni responded in the meantime so I'll add just one more thing:

Which "11g"?! You never stated it an that option didn't evevn exist before 11.1.1.7.

Yossi Belitsky

My version is 11.1.1.9.160119.

Thanks Yossi

Christian Berg-0racle

1435218 wrote:"But I tried this - doesn't work."

So if you had been a bit clearer it'd have been easier :-P  Tried it myself and got "Object expected: /shared/12/_portal/1234" for a dashboard and "Type mismatch of catalog object /shared/12/_portal/1234/123456 -- expected , got ."

Re-reading the doc again:

Downloading data in Excel. This is related to the syntax shown above but replaces the dashboard path with a report path, and adds syntax to download the data in Excel2007 

So it looks like the GoURL just doesn't support downloading the whole dashboard.

Yossi Belitsky

I get it..unfortunately.

thanks a lot for your help.

So, I will have to wait for our upgrade to the OBI12..

Thanks

Yossi