Posts by stan.parker@thefestusgroup.com
Creating a reference to a query that has totals produces an error
You can’t reference a query if the original query has totals. You have to remember to remove all totals fields from the original query that you want to reference.
Read MoreExpress Time As a Percentage To Create a Month-to-Date (MTD) or Year-to-Date (YTD) Value
One of the easiest ways to create an MTD value is to express time as a percentage. Take a look at the following table: Starting with the 1st day of the month add all twelve months. Next subtract each month from the 1st day of the month and divide by the range of 365 to…
Read MoreEnable legacy studios in Cognos Analytics
Step 1: Set the “Configuration.LegacyLaunchable=1” in the<cognos installation directory>\configuration\installData.properties file Step 2: Restart the Cognos service Step 3: Navigate to your Cognos URL in Firefox or Internet Explorer and click New>Other to see the legacy studios like this:
Read More