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.....
You could use MDL scripting to only build the particular cube in the model and use the right prompt specification for that cube.