This content has been marked as final. Show 10 replies
You know that you can automate the outline extractor.
Thanks for your response, can you please provide some insight on this.
I'm not sure if we can automate the oultine extractor. We are using Essbase Outline extractor 3.3.2
If you are using the OLAP undergroup Outline extractor tool (graciously provided by http://www.appliedolap.com/free-tools/outline-extractor) you can call it using command line parameters.
Thanks for responding, I know I can call Outline extractor through command prompt. But can I write a script to extract a particular dimension from an outline and run it on daily basis ?
Is there any other alternate way to extract dimension automatically?
You can do that with the Outline Extractor. It will output each dimension into a separate file.1 person found this helpful
I do this on a daily basis. Batch script that is scheduled, runs outline extractor. Outputs text file for each dimension. Then those files are used in the build of other cubes.
In some cases I take it a step farther and have a vb script that will parse out pieces of dimensions and use those in the builld of other cubes. All scheduled/automated.
Other than that you could build your own custom vb api process to do it.
Or the Star Analytics product will do it.
And I am sure there are other ways that others may chime in with.
Thanks again Sean for responding.
Can you please let me know where can I find documentation on outline extractor tool.
I want to understand how to launch it and which all commands I can use for calling it in dos mode similar to MaxL.
install it and I think somewhere in the installation directory you will find the documentation.
I've the installtion already, but dont see any documentation in the installation directory.
Anyother place where I can find the documentation?
Since Outline extractor is a free ware, we are not supposed to use.
Is there any other way to extract Parent-Child members in two columns ? This extracted dimension is supposed to be used for building other outlines.
Hi,1 person found this helpful
You can do it using 'Oracle Data Integrator'.
Refer to http://john-goodwin.blogspot.in for more info.