COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: mr-sansibar on 13 Jul 2010 08:21:38 AM

Title: Need Bursting-Table to restore in my SQL-Server Database
Post by: mr-sansibar on 13 Jul 2010 08:21:38 AM
Hello,
for my bursting-exercise I need a Bursting-Table.
Normally is the Bursting-Table in the samples-path. From there I restore it in my SQl-Server Database.

Thank you

Ümit
Title: Re: Need Bursting-Table to restore in my SQL-Server Database
Post by: MFGF on 14 Jul 2010 09:33:47 AM
Hi,

I'm not quite following your post.  Do you have a specific question?

Regards,

MF.
Title: Re: Need Bursting-Table to restore in my SQL-Server Database
Post by: mr-sansibar on 15 Jul 2010 05:29:33 AM
For use the bursting-functionality in my reports i need a busting-table.
Title: Re: Need Bursting-Table to restore in my SQL-Server Database
Post by: MFGF on 15 Jul 2010 08:48:02 AM
Not necessarily.  A bursting table is often useful to translate your data values into the relevant CAMIDs or email addresses to use as a burst key, but it is not mandatory.  You could use a report calculation utilising a CASE statement or if-then-else statement to do this translation as an alternative.

It all depends on whether you need to burst regularly when writing reports or if it's just a one-off.

Regards,

MF.