Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

URGENT: Cube Update(Incremental) not Happening In Macro

Status
Not open for further replies.

svivekh

Programmer
Oct 28, 2002
11
0
0
US
Hi all,
We are building a cube using macro. We need to refresh the data daily (as our source system as incremental data). For that we need to update the cube incrementally.

Even when we set the object "Incrementalupdate = true" in Macro the cube is not getting refreshed.

We also tried it by running the transformer model seperately. Then also we could not update the cube.

Is there any other options to do the same? We feel that we are missing something? But dont know exactly what exactly we need to do?

Please help us to solve the problem.

Thankx in advance.

Regards
Anandh
 
SOrry about the tardy post...

Now for the same old question...
Is it possible to see the source code? or a segment of it.

When you rebuild the cube manually following the code does it work?

If so have you set up DCOM for the OS user account you are running under. Are you using ticket server, does the OS acount automatically log in?

What about putting logging into the file and tracing it this way?

That all for now!

Dreffed


Dreffed
 
We update our fully update cubes using batch files scheduled as AT jobs. We've been doing that since version 5 and things continue to work.

Contents of a batch file to populate a cube:
"D:\Program Files\Cognos\cer2\bin\trnsfrmr.exe" -n2 -i -dLogFileName=budget_cube.log "d:\inetpub\ information.pyi"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top