How to Call a Custom Listing in MDX?
Hi, DeepSee experts!
I need to call a listing programmatically other than the default.
I can do that with %LISTING keyword. E.g. in Samples:
SAMPLES>d $SYSTEM.DeepSee.Shell() DeepSee Command Line Shell ---------------------------------------------------- Enter q to quit, ? for help. >>DRILLTHROUGH SELECT FROM [HOLEFOODS] %LISTING [Listing] # ID Date City Chan Prod Unit Reve Disc Comm 1: 475 01/1 Madr Reta Life 1 0.92 20% 2: 843 01/1 Manc Onli Frui 1 4.95 0% 3: 808 01/1 Osak Onli Bund 4 79.8 0%
But how can I call custom listings in MDX? E.g. there are 3 custom listings available in SAMPLES HoleFoods Cube:
And they work in pivot but %LISTING says that it doesn't know them.
>>DRILLTHROUGH SELECT FROM [HOLEFOODS] %LISTING [Custom Listing] ERROR #5001: Listing does not exist: ('Custom Listing' @pos 63) >>