COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Framework Manager => Topic started by: Sans on 26 Sep 2019 02:55:20 AM

Title: Packages Elements Source
Post by: Sans on 26 Sep 2019 02:55:20 AM
Hi

My customer with C11.2 BI has a funny request I'd like to answer:

He asked to be able to have a table (excel, csv...) having the info about the source of each element componing the package.

I.E.   
Let's suppose to have a Package containing 10 Query Subjects ( 5 arriving from table A and 5 arriving from table B), looking at them he'd like to get a table with the following data:

Package      Data                              Query        Query         Query             Query        Query       Query        Query      Query        Query     
                   Container                   Subject 1   Subject 2  Subject 3 ......  Subject 5  Subject 6  Subject 7  Subject 8  Subject 9  Subject 10
-------------   ------------------------    --------------------------------------------------------------------------------------------------------------------------------
XYZABC       123ABCDE                    Table A       Table A       Table A.........   Table A      Table B     Table B      Table B      Table B      Table B

My idea was to look at SQL generated and re-build the origin of each element, but it's a big big job; I have a package with more than 400 elements !!!

Is there any simple and clever way to do it ??

Thnaks

Title: Re: Packages Elements Source
Post by: MFGF on 26 Sep 2019 07:14:45 AM
Quote from: Sans on 26 Sep 2019 02:55:20 AM
Hi

My customer with C11.2 BI has a funny request I'd like to answer:

He asked to be able to have a table (excel, csv...) having the info about the source of each element componing the package.

I.E.   
Let's suppose to have a Package containing 10 Query Subjects ( 5 arriving from table A and 5 arriving from table B), looking at them he'd like to get a table with the following data:

Package      Data                              Query        Query         Query             Query        Query       Query        Query      Query        Query     
                   Container                   Subject 1   Subject 2  Subject 3 ......  Subject 5  Subject 6  Subject 7  Subject 8  Subject 9  Subject 10
-------------   ------------------------    --------------------------------------------------------------------------------------------------------------------------------
XYZABC       123ABCDE                    Table A       Table A       Table A.........   Table A      Table B     Table B      Table B      Table B      Table B

My idea was to look at SQL generated and re-build the origin of each element, but it's a big big job; I have a package with more than 400 elements !!!

Is there any simple and clever way to do it ??

Thnaks

Hi,

Have you shown the Lineage option to your customer? This is built in to Cognos Analytics and allows you to select an item and see its origin. If it answers the requirement it may save you a lot of work?

MF.