Posts by agoddard
Using PAW Calculations
Interactive Map Visualizations (PAW)
Why Won’t My TM1 (Planning Analytics) Server Start and How Do I Fix It?
TM1 Server won’t start Issue: tm1s.log file may become corrupt Resolution: Rename existing tm1s.log and restart TM1 server. TM1 will create a new tm1s.log file. Tm1server.log file is located in the Logs folder. This will most likely be in the same location as your Data and Config folders. Rename tm1server.log to tm1serverold.log Restart TM1 server…
Read MoreHow Do I Add and Manage External Data Sources in Cognos Analytics 11 for Reporting and Dashboards?
“I’ve just been emailed an updated set of comments. How can I update the spreadsheet in Cognos?” A great feature in COGNOS Analytics 11 is the ability to supplement your enterprise data with personal or external information. This is a tangible time saver when you have supplemental information for a report or dashboard. In the…
Read MoreHow Do I Create Drill-Through Reports in Cognos Analytics 11 to Navigate Between Related Reports?
“How can I make sense of this information? It’s too much detail!” The example above shows sales information by Branch and City. However, this type of list report does not clearly tell us the story or answer the questions we may have. (i.e. What is the highest revenue earning city, what is the gross profit…
Read MoreWhat Are JavaScript Modules in Cognos Analytics and How Do They Enable Custom Report Enhancements?
Cognos Analytics JavaScript modules are useful tools to customize reports with JavaScript and JQuery. Whether integrated into pages or custom controls, these modules can be reused to tailor your report precisely to your needs through the use of JavaScript’s extensive library. In this video, we’ll be showing you the ability of JavaScript to create custom…
Read MoreHow Do I Apply Conditional Styling to Highlight Data in a Cognos Analytics 11 Report?
“OK, I have a data dump. What is this supposed to tell me? The example above shows sales information by product. However, this report is no different than a spread sheet. Sure, I can dump the data into an Excel Pivot table, but it is time consuming and fraught with human error. I want the…
Read MoreReducing Calculations with Text – Anaplan
Reducing Calculations with Text in Anaplan Reducing Calculations in Anaplan improves performance, and I am not referring to reducing line items. I am talking about the pieces of each formula in the line items. Anaplan’s engine is designed primarily to complete tasks that are Boolean, followed by numerical, like most computers. When you leverage text,…
Read MoreFormatting Line Items in a Module – Anaplan
When working in an Anaplan module, it is important to have line items set to the correct format that match the format of the data being imported into the model. When line items are added to a module, their default format setting is Number. While some of your line items may need to be formatted…
Read MoreCreating List Subsets in Anaplan
Creating a subset of list items in Anaplan is an easy way to create a smaller list of items out of a larger list. A subset can be maintained manually or imported along with other list properties. This subset list can then be used as a dimension when creating a module just like any other…
Read More