Hi , I have a cube built from cognos transformer and its built daily .
I have to burst some reports from this cube data.
I am planning to have the burst information which is a relational table with data item and corresponding email id.
How should I add this burst information ?
Should it be added as part of transformer only or should I add it as an external data .
Thanks,
Nithya
Quote from: nithya1224 on 27 Apr 2015 11:55:56 AM
Hi , I have a cube built from cognos transformer and its built daily .
I have to burst some reports from this cube data.
I am planning to have the burst information which is a relational table with data item and corresponding email id.
How should I add this burst information ?
Should it be added as part of transformer only or should I add it as an external data .
Thanks,
Nithya
I'd recommend you add it as a query subject in Framework Manager, and have a package that references both the cube and the query subject. When you burst, create a list object that references the query subject, and drag your crosstab/chart objects from the cube inside this list, then link them via master/detail relationships.
Cheers!
MF.