Create Prompt Specification

[Northern_Monkey]

I have transformer model which uses a package as a datasource.
The package is made up from a SQL statement that contains macros/prompts.

I can create a a prompt specification XML file and use it when i am doing a cube build:

C:
cd "C:\Program Files\cognos\c8\bin"
cogtr.exe -n1 -s -r4 -f"XXX.xml" "XXX.mdl"

The problem is, if i have multiple cubes in the model it passes through the XML for each one when it builds when what i really want is to pass through a different XML file for each PowerCube. Can it be done?

You're probably thinking that i should just create one model per PowerCube. Problem is that the client does not want to manage all the various models.

Another way i thought i could do it would be to create various Prompt Specification XML files and and run them separately against the model but i do not know a way i can script the PowerCube to have different names dependant on what i want.
eg,


cogtr.exe -n1 -s -r4 -f"A.xml" "Sample.mdl" -> Output Cube = A
cogtr.exe -n1 -s -r4 -f"B.xml" "Sample.mdl" -> Output Cube = B
cogtr.exe -n1 -s -r4 -f"C.xml" "Sample.mdl" -> Output Cube = C

Any help would be greatly appreciated.....

[nybble]

You could use MDL scripting to only build the particular cube in the model and use the right prompt specification for that cube.