BI Data Analytics

Below are few tips to set up Excel for Data Analysis: How to create table and name it? In Excel Tab, click on any cell with data in it and press Ctrl +T. Excel will automatically select all columns and rows that have data. Click OK to create Table. In Tab, click on any cell that have data. In Top Menu Bar, select Design Tab. In top left hand side of screen, find table name option to change name from Table1 to Name you want to change to. How to activate Excel Solver add-in? Select File - Options - "Add-Ins" Option and click GO button Check the box labeled "Solver Add-in" and click OK Navigate to Data Tab and see new button for Solver Add-in How to enable Developer Tab to view macros? Select File - Options - Click "Customize Ribbon" On the right-hand side of the Excel Options dialog box, check the Developer checkbox and click OK Check that  DEVELOPER  menu has been added to the ribbon. Shortcuts: # ALT+F11 - To invoke VBA Edi

Requirement: Grant  Access permission to Library Tab only to RAVE developers Solution: By Default, Library Administrators Members can access, import, and administer the contents of the Library tab in IBM Cognos Administration.  However. User should already  be part of Portal Administrator. Go to Admin - Security tab to make below changes: Add required group/member to Cognos Predefined role of Library Administrator Add required group/member  to Cognos Predefined role of Portal Administrator Now Developer should be able to see Library Tab in Admin Console.