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

Packages Elements Source

Started by Sans, 26 Sep 2019 02:55:20 AM

Previous topic - Next topic

Sans

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


MFGF

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.
Meep!