hi I am trying to build cubes us

[spicysudhi]

hi

I am trying to build cubes using a macro. the scriptlet is as below,

Set objCubeItem = objModel.Cubes.Item(1)
lobjCubeStatus = objCubeItem.CreateMDCFile()

it works fine when the model contains only one cude, but the CreateMDCFile() returns false when the model contains the Cube Group.

regards,
Sudhi

 

[drlex]

Sudhi,
Why not try the .CreateMDCFiles method?
e.g.
Set objTransApp = CreateObject("CognosTransformer.Application&quot
Set objModel = objTransApp.OpenModel("D:\PPModels\SalesWeeklyDW.pyi&quot
With objModel
.CreateMDCFiles
.Update
.SaveAs "D:\PPModels\SalesWeeklyDW.pyi"
.Close
End With
lex

 

[spicysudhi]

yes, i tried that. but the problem is i am trying for a generalized program to build the cubes.

if it is a single cube, we have to use the .createmdcfile() if group we have to use the .createmdcfileS()

how to identify whether it is single or a group !?

i am doing something like this

for i=1 to objmodel.cubes.count
Set objCubeItem = objModel.Cubes.Item(i)
lobjCubeStatus = objCubeItem.CreateMDCFile()
next


because my model has multiple cubes (combination of single and groups)

regards,
sudhi

 

[spicysudhi]

thanks lex, i sorted out this using cubegroup instead of cubeitem

regards,
sudhi

 

[MacintoshF16]

Hi Sudhi

Please ,can post that script creating multiple cubes from single model.

I would appreciated u , if u post that script. I am facing some problems on this, its very urgent for me.

Thanks in Advance

Macintosh