List of Objects and Variables used in WebI report

system · March 31, 2010, 8:15pm

Hello Gurus,
Is it possible to get the list of variables and objects, and variable formula used in a webi report extracted in excel or PDF.

Please help.

Daisy

Nimu (BOB member since 2004-04-27)

system · March 31, 2010, 8:42pm

Hi daisy -

You may want to have a look at the WID Scanner Utility in the BOB Downloads section (I don’t believe it locates report expressions though)

Your other options are:

Develop a custom application using Report Engine SDK
Use a 3rd party tool for collecting this data

Hope this helps

Atul Chowdhury (BOB member since 2003-07-07)

system · April 1, 2010, 1:53pm

Thanks Atul,
I am not a SDK person but do you know of any 3rd party tool which can help me with this process.

Nimu (BOB member since 2004-04-27)

system · April 1, 2010, 2:32pm

Hi daisy -

We develop an add-on that does this as do several other partners. Kindly leave me a note at my profile email and I can send something along. (note: this is not the same as our eval download currently available)

Other solutions that also do this are:

Eric Vallo’s product - http://www.savethecms.com
Analytics8’s System Profiler - http://www.analytics8.com/system-profiler
EbiExperts (possibly) http://www.ebiexperts.com

Hope this helps.

Atul Chowdhury (BOB member since 2003-07-07)

system · November 24, 2010, 10:31pm

hi Nimu - Did you ever find a solution for this? Were you able to get a macro or tool to list all the variables used in a webi report?

Thanks in advance!
Maddy

maddyforums (BOB member since 2006-02-23)

system · December 22, 2010, 8:33pm

Nope.
Try CMSConnect from Infolytik they give you a free universe for XI 3.1

Nimu (BOB member since 2004-04-27)

system · December 23, 2010, 4:53am

Hi.

I am not sure if this is what you are after but I hope it helps:

http://www.dagira.com/2009/12/11/quick-tip-detailing-web-intelligence-document-contents/

Voztron (BOB member since 2010-12-08)

system · January 5, 2011, 8:48pm

very useful doc - thanks a lot

maddyforums (BOB member since 2006-02-23)

system · January 14, 2011, 10:26am

Useful document as I’ve been trying to get a list of variables but I’m using Rich Client and can’t work it out!

KA_Analyst (BOB member since 2009-02-24)

system · February 15, 2011, 10:44am

This document is very useful. Does anyone know how to extract the contents into an excel sheet ? (instead of printing)

bulgaru10 (BOB member since 2006-12-15)

system · February 17, 2011, 4:29pm

unfortunately there is no feature in webi to extract this into a excel. But we can always copy and paste this into a excel which might work for you.

maddyforums (BOB member since 2006-02-23)

system · February 18, 2011, 7:10pm

I am also using Dave’s method and extracting into excel manually - it is better than opening the field up to see what it is. Unfortunately i also have to use the Lineage Analysis to further decompose the measures and dimensions back to the universe and tables/fields. That tool is blazingly slow.

amartinhigh (BOB member since 2009-06-24)

system · March 4, 2011, 3:04pm

Hello All,

I’m really frustrated right now. All I’m looking is a way to find out the objects, variables, formula used in the Webi reports. The WEBI Scanner doesn’t do that.

Is there a solution for this other than the beautiful way of using the Data Summary?

Really appreciate if there’s a alternative solution to this.

Cheers!
Santosh

vsantoshkumar (BOB member since 2008-06-02)

system · December 28, 2011, 7:18pm

Hi,

I have posted the Java code, here is the link

Thanks,
Rupesh

Rupesh G (BOB member since 2009-10-22)