Hi,
I have created a MDL file with IQD as data source. I am able to generate, update powecube from transformer tool. I need to do regular cube updated on daily basis. I need to configure Cognos scheduler to update the cube regularly.
I tried through command line option and it is not working.
Please help me how this can be done.
I even tried using Macro script. It is giving me error TR0118, which means transformer cannot read database. Actually there is nothing wrong with datbase & sql connectivity to that database.
Please help me how I can achive cube refresh.
Cheers,
Vinay
I have created a MDL file with IQD as data source. I am able to generate, update powecube from transformer tool. I need to do regular cube updated on daily basis. I need to configure Cognos scheduler to update the cube regularly.
I tried through command line option and it is not working.
Please help me how this can be done.
I even tried using Macro script. It is giving me error TR0118, which means transformer cannot read database. Actually there is nothing wrong with datbase & sql connectivity to that database.
Please help me how I can achive cube refresh.
Cheers,
Vinay