If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

What tables are involved in the incremental publish?

Started by andy_acacia, 27 Apr 2012 09:42:24 AM

Previous topic - Next topic

andy_acacia

Software - Cognos 8.3.12.27
Database - DB2

The incremental publish feature is useful in saving server resource and time in publishing to publish tables. But I wish to replicate this saving when pulling data into TM1.
The incremental publish only replaces data in an existsing table in the database. I only wish to pull data into TM1 that has changed. How can I do this?

What tables are used in the incremental publish?
Is there a flag in a table that shows the status of data since last publish (ie. 1=data changed, 0=no change)?

I ask these questions because my idea is to interregate the databse table to check "flag" status (I assume by entity??) and if it meets the condition then load the data from the matching entity in the publish table to TM1.
I am wanting to avoid multiple "staging" cubes in TM1 that compare current vs previous as this defeats the object of efficiency.

I have assumed that the incremental publish functions using "flags" and tables but please correct me and let me know how it does work.

Thanks in advance.

SomeClown

I forget what it's called in 8.3 but something like nodelanguagemodel or nodestate has the datadatachanged column (don't remember the exact names).  Check out Yuri's post from long ago on it http://ykud.com/blog/cognos/more-on-real-time-reporting-on-contributor for additional info.

Been a while since I've looked at incremental. I don't think there's an incremental delta table.  I think in 8.3, it just republishes the entire node's set of data, rather than specific cubes.  I don't think finer granularity on publish shows up until 10.1

andy_acacia

Thanks SomeClown

its now Saturday evening so my priority at the moment is beer. I will take a look at the tables on Monday. The blog post was very useful!

andy_acacia

"I don't think there's an incremental delta table.  I think in 8.3, it just republishes the entire node's set of data, rather than specific cubes"
- Yes, the entire node appears to be published. This isnt useful if a change was only made to a single cell - but better than nothing.

The NODESTATE table contains the column DATADATETIME. This indicates the time data was last saved. So, I could compare the previous date to the current date and pull in data where the DATADATETIME changes?
How would I do this by entity?
The only column that appears logical is the NODEGUID column. Is there a relationship between the NODEGUID and the ITEMID or ITEMNAME in the IT_* table?