Sample Example on How To Extract Worksheet IDs of a Workbook through Discoverer Desktop via the d51wkdmp utility
Sample Example on How To Extract Worksheet IDs of a Workbook through Discoverer Desktop via the d51wkdmp utility
Syntax:
d51wkdmp.exe <Workbook_Name> <Output_File> DB <Connect_String> <Eul_Schema> -f
(1) Log into your pc where Discoverer Desktop is installed.
(2) Find out the exact location of the ‘d51wkdmp.exe’ file.
(3) Click <Start> <Run> and enter ‘cmd’ to go to command prompt.
(4) Enter and run the following at the prompt, for example:
C:\> d:\oracle\BI_1012\bin\d51wkdmp.exe “Employee By Dept” Outfile2.txt DB scott/tiger@TestDB1 Eul_owner -f
WHERE there are 3 Worksheets in this example.
RESULT: Outfile2.txt
EUL Item Reference
IoId = 16
Id = 100671
Identifier = DEPTNO
Name = Deptno
Folder Identifier = EMP_1
Folder Name = Emp 1
*** Found in EUL by id ***
EUL Item Reference
IoId = 24
Id = 100664
Identifier = EMPNO
Name = Empno
Folder Identifier = EMP_1
Folder Name = Emp 1
*** Found in EUL by id ***
EUL Item Reference
IoId = 32
Id = 100665
Identifier = ENAME
Name = Ename
Folder Identifier = EMP_1
Folder Name = Emp 1
*** Found in EUL by id ***
EUL Item Reference
IoId = 40
Id = 100666
Identifier = JOB
Name = Job
Folder Identifier = EMP_1
Folder Name = Emp 1
*** Found in EUL by id ***
EUL Item Reference
IoId = 48
Id = 100667
Identifier = MGR
Name = Mgr
Folder Identifier = EMP_1
Folder Name = Emp 1
*** Found in EUL by id ***
EUL Item Reference
IoId = 56
Id = 100668
Identifier = HIREDATE
Name = Hiredate
Folder Identifier = EMP_1
Folder Name = Emp 1
*** Found in EUL by id ***
EUL Item Reference
IoId = 64
Id = 100669
Identifier = SAL
Name = Sal
Folder Identifier = EMP_1
Folder Name = Emp 1
*** Found in EUL by id ***
EUL Private Item
Id = -32
Name = Sal SUM
Identifier = 7
Desc =
DataType = 2
Placement = 1
Hidden = 0
IsACalc = 0
IOFormula = [1,1]([6,64])
DisplayFormula = SUM(Sal)
Query Request QR1
Distinct = 1
Axis Item Usage – Name = EUL Item – Emp 1.Empno
Axis Item Usage – Name = EUL Item – Emp 1.Ename
Axis Item Usage – Name = EUL Item – Emp 1.Job
Axis Item Usage – Name = EUL Item – Emp 1.Mgr
Axis Item Usage – Name = EUL Item – Emp 1.Hiredat
e
Axis Item Usage – Name = EUL Item – Emp 1.Deptno
Measure Item Usage – Name = Calculation – Sal SUM
Identifier = 68
///////////////////////////////////////////////////////////////////////////////
Sheet Number 1
///////////////////////////////////////////////////////////////////////////////
Sheet Name = Sheet 1
Sheet Unique Name = Workbook 11503332070
Sheet Identifier = 1
Query(s) used =
Query 1
Items :-
EUL Item – Emp 1.Empno
EUL Item – Emp 1.Ename
EUL Item – Emp 1.Job
EUL Item – Emp 1.Mgr
EUL Item – Emp 1.Hiredate
EUL Item – Emp 1.Deptno
Calculation – Sal SUM
///////////////////////////////////////////////////////////////////////////////
