How to build cude automatically

[khoinh]

Hi,

    I designed a cube by Transformer tool from one package that I created by Framework Manager. In the first day of each month, I always rebuild my cube. How can I do this task with my defined schedule ? And I also want to receive alert email about result of this rebuild.

Thanks

[Sarayucog]

Hi,

How you are running you cube. Is it manually or by using any shcedule task.

If it is by schedule task

Goto your shcedule task. Double click on that and go to SCHEDULE tab.

In Schedule task monthly pane

Select 1st radio button and select day as 1 and click on OK.

Now onwards it will runs the cube 1st day of every month.

[khoinh]

At now, I'm doing this task by manually by openning Transformer tool/Build Cube. How can I do automatically ?

[Sarayucog]

C:
cd "C:\Program Files\cognos\c8.4-disp_1\bin"
C:cogtr.exe -n2 -i -s "D:\Path_of_ur_model\Model_name.pyj"

The above code will run ur cube autiomatically.

Write the above code in a notepad and save it as .bat.

From Controm panal goto schedule and tasks. Here create a schedule task and assign the avobe create .bat file to this schedule task and use the previous reply settings to run ur cube as ur requirement.

cscript D:\Ptath_of_ur_VB Script file\VBScript_File_Name.vbs

If you want to check the errors you have to write a VB Script file. If you have VB Script file add this line ( cscript D:\Ptath_of_ur_VB Script file\VBScript_File_Name.vbs ) in your .bat file.

ejoy  :)     

[cognostechie]

You also have to disable the data source to the cube before you execute the build command using 'cogtr'. If you don't , it might error out if somebody is connected to the cube. Afetr building it, enable the data source. This is the easy way to automate it.

In 8.4, you can also build it and 'activate' after building it. The Transformer user guide has commands for automating cube builds using PCConnect utility.

[bdbits]

In Cognos 8.4 you do not have to disable the data source, and if you set the properties on the cube correctly it will automatically deploy without disconnecting the active users or requiring any additional software to run beyond Transformer. This became possible sometime in the 8.x versions, I think it was 8.3 but I cannot be sure.

The following link to the on-line manual has all the command line options for Transformer.

http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cogtr.8.4.0.doc/ug_cogtr_id11786CommandLineOptions.html

[cognostechie]

That's exactly what I meant about 8.4 > I stated about disabling Data Sources because the original poster did not mention what version he is using.

The feature you are talking about was introduced in 8.4, not 8.3. It connects the user's report to the newly built cube which is called 'activation'.

[khoinh]

Hi

  I used this script in my file:
C:
cd "C:\Program Files\cognos\c8.4-disp_1\bin"
C:cogtr.exe -n2 -i -s "D:\Path_of_ur_model\Model_name.pyj"

   My script ran successfully but I did not see my category file is updated (ABC.mdc). How can category file be updated? I'm working in Cognos v8.4

One more question: if there are two cubes (A and B) are defined in my package (Model_name.pyj) and I only want to rebuild A cube. How can I do it?

Thanks

[khoinh]

Hi,

  After my script was done, transformer requested me to input account before it completed. How can I skip this step "type account"?

Thanks