can cubes be rebuilt using command line commands.

[unarayan]

I have a report developed in report Net that is taking too long to run.

1. Will building a cube help speed this up?
2. Is there a way to rebuild the cube from the command line? I ask this question because I want to be able to schedule the rebuilding/refreshing of this cube based on the completion of some other events. We have one other cube which we manually go in and rebuild at the right time. I'd really like to schedule teh rebuild rather than doing it manually.

 

[drlex]

unarayan
Can't help you on Q.1, but for Q.2, try the following:
"<path to transformer directory>\trnsfrmr.exe" -n2 -s -i -nologo "<path to .pyi model file>\<your model filename>.pyi"

Note that by using the .pyi version, it includes the signon information for the data sources, as opposed to the .mdl version.


soi la, soi carré

 

[drlex]

should have added that the command line options for transformer are related in the pdf "pp_sbs_trans" at Appendix C; the pdf should be in "documentation" within the cern folder.

soi la, soi carré

 

[ztork]

Are there any other differences between automating a .pyi and .mdl file? We've tried start /w "<path to transformer directory\trnsfrmr -n -s " ",path to .mdl directory>". This opens transformer but then it just sits there and doesn't perform the cube rebuild.

 

[Draoued]

check the log file to see if there is an error message.

And as Drlex said for MDL you have to specify the db signon with : -kdatabasename=userid/password

 

[unarayan]

Do I need the SDK installed to use this feture.

Thanks for all your help. I'll try that and get back.

 

[Draoued]

The SDK is not needed to run cubes from command line.

 

[unarayan]

Thank,

can you also tell me weather I can run a report-net report from the command-line. We use a scheduler called appworx and I'd really like to schedule a report-net report using the same tool rather than Cognos's scheduler.

Will I need to install Cognos's SDK for this purpose?

 

[Draoued]

why don't you use the reportnet scheduler ?? It s embedded in repornet and running smoothly.

 

[unarayan]

Because the report needs to be scheduled based on the completion of other events which Appworx is currently scheduling.

 

[avitabj]

Hi! Most of my reports have an "Event Name" set on the "Run Options" of the report. I used the ReportNet SDK to create a java program that is run during our nightly CDW processing to trigger the event when all the data is available for the report. If you have the SDK, this should be pretty easy and I think Cognos supplies a sample at least for java.

Good Luck!