cognos finance tips & techniques part i aimee sousa cognos
TRANSCRIPT
![Page 1: Cognos Finance Tips & Techniques Part I Aimee Sousa Cognos](https://reader035.vdocuments.us/reader035/viewer/2022062301/56649ebe5503460f94bc85c2/html5/thumbnails/1.jpg)
Cognos Finance Tips & Techniques
Part I
Aimee Sousa
Cognos
![Page 2: Cognos Finance Tips & Techniques Part I Aimee Sousa Cognos](https://reader035.vdocuments.us/reader035/viewer/2022062301/56649ebe5503460f94bc85c2/html5/thumbnails/2.jpg)
CF Security
• Master Password – C8 security– Access Manager security
• V7.4 MR1 integrated with Cognos8– Add groups, roles, users to CF– http://server_name/cognos8/cgi-bin/cognos.cgi– No backward capability
![Page 3: Cognos Finance Tips & Techniques Part I Aimee Sousa Cognos](https://reader035.vdocuments.us/reader035/viewer/2022062301/56649ebe5503460f94bc85c2/html5/thumbnails/3.jpg)
Dimension Attributes
• All dimensions can have user-defined attributes
• Can sometimes replace a component dimension• Can be used in Account calculations -
@IN(DIMNAME.ATTRNAME “ID1” “ID2”)– replaces CT and CLASS in account calcs
• Can provide greater flexibility and information in reports
![Page 4: Cognos Finance Tips & Techniques Part I Aimee Sousa Cognos](https://reader035.vdocuments.us/reader035/viewer/2022062301/56649ebe5503460f94bc85c2/html5/thumbnails/4.jpg)
@IN Calculation
![Page 5: Cognos Finance Tips & Techniques Part I Aimee Sousa Cognos](https://reader035.vdocuments.us/reader035/viewer/2022062301/56649ebe5503460f94bc85c2/html5/thumbnails/5.jpg)
Reporting on Attributes
• Attributes can be used in reporting for analysis with the use of system defined filter functions:
• @ATEXT
• @LIST
• @GROUP
• @TOTLIST
• @TOTAL
![Page 6: Cognos Finance Tips & Techniques Part I Aimee Sousa Cognos](https://reader035.vdocuments.us/reader035/viewer/2022062301/56649ebe5503460f94bc85c2/html5/thumbnails/6.jpg)
Item Selection
• Exchange
• Attributes
• Dependencies
• Libraries– Loaded/Embedded– Static/Dynamic
![Page 7: Cognos Finance Tips & Techniques Part I Aimee Sousa Cognos](https://reader035.vdocuments.us/reader035/viewer/2022062301/56649ebe5503460f94bc85c2/html5/thumbnails/7.jpg)
Dependencies
• Increases the efficiency of maintaining reports
• Updates reports automatically when new items added to database
• CF remembers item relationships better than the report author remembers
![Page 8: Cognos Finance Tips & Techniques Part I Aimee Sousa Cognos](https://reader035.vdocuments.us/reader035/viewer/2022062301/56649ebe5503460f94bc85c2/html5/thumbnails/8.jpg)
Saving Libraries
• Done on any Item selection screen– Saves selections and calculations– Can be loaded on any item selection screen that
allows multiple selections
• Done from Select Option– Row libraries– Column libraries– Saves selections, calculations and formatting
![Page 9: Cognos Finance Tips & Techniques Part I Aimee Sousa Cognos](https://reader035.vdocuments.us/reader035/viewer/2022062301/56649ebe5503460f94bc85c2/html5/thumbnails/9.jpg)
Loading Libraries
![Page 10: Cognos Finance Tips & Techniques Part I Aimee Sousa Cognos](https://reader035.vdocuments.us/reader035/viewer/2022062301/56649ebe5503460f94bc85c2/html5/thumbnails/10.jpg)
Embedding Libraries
• Retrieve the current version of the library selections each time the report is loaded
• Only valid for row, column, and page libraries
![Page 11: Cognos Finance Tips & Techniques Part I Aimee Sousa Cognos](https://reader035.vdocuments.us/reader035/viewer/2022062301/56649ebe5503460f94bc85c2/html5/thumbnails/11.jpg)
Static v. Dynamic
• Static – does not change – Items loaded once– Selections remain as they were when loaded until
manual intervention
• Dynamic – changes– library contents, and therefore selected items, can
change based on changes in Define Items (hierarchy or attributes)
![Page 12: Cognos Finance Tips & Techniques Part I Aimee Sousa Cognos](https://reader035.vdocuments.us/reader035/viewer/2022062301/56649ebe5503460f94bc85c2/html5/thumbnails/12.jpg)
Load v. Embed
• Reading/Retrieving library– Load = Define / create
• Can be dynamic– Dependencies
– Embed = Runtime• Can be dynamic
– Dependencies
– Links
![Page 13: Cognos Finance Tips & Techniques Part I Aimee Sousa Cognos](https://reader035.vdocuments.us/reader035/viewer/2022062301/56649ebe5503460f94bc85c2/html5/thumbnails/13.jpg)
Linked
• References the name of a library– Allocation table– Extract module
• Interpreted at runtime (dynamic)
![Page 14: Cognos Finance Tips & Techniques Part I Aimee Sousa Cognos](https://reader035.vdocuments.us/reader035/viewer/2022062301/56649ebe5503460f94bc85c2/html5/thumbnails/14.jpg)
Allocation Libraries
![Page 15: Cognos Finance Tips & Techniques Part I Aimee Sousa Cognos](https://reader035.vdocuments.us/reader035/viewer/2022062301/56649ebe5503460f94bc85c2/html5/thumbnails/15.jpg)
Cognos Finance, moving forward.
Q & A