BI Data Analytics

Requirement: Users request to provide all report name with Report URL and possible prompt default selection so that they can embed in their external web page for user publishing in the way they want to organize. Report Search path that can be obtained from Audit database: /content/folder[@name=’Samples’]/folder[@name=’Models’]/package[@name=’GO Data Warehouse (analysis)’]/folder[@name=’Report Studio Report Samples’]/report[@name=’Revenue by Year’] Case I: When XSS checking is not enabled, below Cognos Proven Practice document can be used to understand how URL is formed: http://public.dhe.ibm.com/software/dw/dm/cognos/reporting/scripting_techniques/using_urls_in_cognos_8.pdf Case II: When XSS checking is enabled for highly secured intranet environments. Below link provides what needs to be done to encode URL to be compatible:- http://queryvision.com/custom-cognos-url-support-and-cross-site-scripting/ Design: You can use Cognos to create a report to do the encoding

In Excel, there is funciton to remove duplicates; however, didn't find direct method to identifying duplicates based on specific columns. Below is step created to find out duplicate ID columns for further analysis: Column A contains all Customer IDs. We need to identify how many rows are generated for a customer id. Step 1: Sort based on Column A Step 2: Add 3 Columns with below calculations =COUNT(MATCH(A10,A11,0)) as B10 =COUNT(MATCH(A10,A9,0))  as C10 =IF(B10=1,1,IF(C10=1,1,0)) or B10+C10  as D10 Now You can use D10 to filter on 1 to list down all duplicate records for further analysis for reason of what values are different or any other purpose.