One on my customers wants to use the SYSCOLUM master to extract data from the MASTER of a SSAS cube, specifically FIELDNAME, ALIAS, TITLE and WITHIN. The first 3 are accessible, the last is not. I tried DIMEN_NAME to no avail. Any ideas?This message has been edited. Last edited by: Danny-SRL,
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
October 26, 2015, 01:15 PM
j.gross
Dan -
Did you try
CHECK FILE ... HOLD ALL
?
October 26, 2015, 05:00 PM
Waz
According to the samples it looks like DIMEN_NAME DIMEN_ID DIMEN_LEVEL have the details
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
October 27, 2015, 12:13 AM
Danny-SRL
Tried both. Neither produced.
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
October 27, 2015, 12:28 AM
Waz
Interesting, I checked the master SHORT in IBISAMP, and the WITHIN is populated in these columns.
Perhaps you can compare how its implemented in the cubes master ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
October 27, 2015, 03:40 AM
Danny-SRL
Using TABLE FILE SYSCOLUM on the SHORT master shows via DIMEN_NAME the fields with WITHIN values starting with * and the fields linked. For example fields CONTINENT, REGION and COUNTRY all have DIMEN_NAME = Geographic Area. However, sadly, this is not the case for a CUBE master: DIMEN_NAME is blank.
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
October 27, 2015, 02:59 PM
Waz
I'm interested in what is in the master, can you post it ?