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