If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

SliceCommand Macro

Started by kostlin, 06 Jun 2007 03:01:04 AM

Previous topic - Next topic

kostlin

Hi,
I would like some help with the SliceCommand or SliceUpdate macro step.

I have a 5 Dimensional cube which has a D-list of “products” and another list with details about the products by department by some other dimensions.

I would like to take a slice of the cube where the products are valid “Yes” and export it to .txt file. A field for valid products is NOT in the 5 Dimensional cube but is stored in another 2 dimensional cube which has all the products with a D-list formatted single d-list which is either “yes” or “no”.

How can I use these cubes to create the export file that only contains products that are valid (based on the yes no field in the small 2D cube)?

I do not understand the 3 options one needs to choose from within the macro steps
Many thanks

kostlin

I have figured out how to use the slice command but I don’t think it’s what I wanted   :(

it seams I can only use the @Command macro so cant actually open the cube as a selection of what I wanted to export. Does anyone have any ideas for me how to open a selection of a cube based on some criteria in a separate cube as in my post above??

ykud

A number of indented slices will work you out.
DCubeCommand(export) for exporting.

ykud

Update:
Sorry for @DCubeCommandOpen  -- it doesn't work with @SliceCommand, I forgot.
Maybe you can make a copy of 5 dimensional cube, fill it up using update-links with @SliceUpdate from initial cube, and then export it suppressing zeros?

kostlin

Thank you for the help.
I actually decide to use the DCubeCreateDSel command and this works fine for me.
thanks you for your help.