by ·Comments Off on Check that parameter year is 4 characters

Product:

Planning Analytics 2.0.9.19
Microsoft Windows 2019 server

Issue:

How to add extra withlist on prompts, to ensure the value is somewhat correct, before processing?

Suggested solution:

If you have a prompt pYear and pMonth, you can have below code in prolog:

 

# if year is blank enter current year
IF (pYear  @= '') ;
pYear = NumberToString( Year ( Today (1) ) ) ; 
ENDIF;

# if year is not 4 characters - stop the process
IF (LONG (pYear ) <> 4);
sErrorMessage = 'Year is not correct value';
ItemReject ( sErrorMessage ); 
ProcessQuit;
ENDIF;

# add zero if only one digit
IF (LONG (pMonth) = 1) ;
pMonth = '0' | pMonth  ;
ENDIF;

# check that month is 2 digits

IF (LONG (pMonth) <> 2) ; 
ProcessQuit ;
ENDIF;

More Information:

https://www.ibm.com/docs/ru/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ref.2.0.0.doc/tm1_ref.pdf 

https://nvlpubs.nist.gov/nistpubs/specialpublications/nist.sp.800-167.pdf

https://exploringtm1.com/year-function-tm1-syntax-use/

by ·Comments Off on Click on cell give that outlook starts

Product:
Planning Analytics 2.0.9.19
TM1 perspective
Microsoft® Excel® for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20550) 32-bit

Issue:

Then create a websheet with formulas, when it refresh the formulas change to =@TM1RPTROW.

Excel will treat any value containing an @ as an email address.

 

Solution:

For a single cell right click and go down the menu which appears to link -> “remove hyperlink.”
Release mouse and the hyperlink is disabled in that cell.

To prevent it to happen in future:

Go to menu File > Options > Proofing > AutoCorrect Options > Click Tab AutoFormat As You Type > Uncheck Internet and network paths with hyperlinks > OK

 

 

 

More Information:

https://support.microsoft.com/en-us/office/remove-or-turn-off-hyperlinks-027b4e8c-38f8-432c-b57f-6c8b67ebe3b0 

 

by ·Comments Off on Subset editor does not show in TM1 Perspective

Product:
Planning Analytics 2.0.9.19 TM1 Architect

Microsoft Windows 2019 server

Issue:

When open a cube view in TM1 Explorer from TM1 Perspective on my laptop, and click on the dimension to get the subset editor, A beep hears but no dialog is shown. The cube view is frozzen, and only way out is to exit TM1 architect.

 

Solution:

When moveing your laptop between desks at the office, and connect it to diffrent displays with diffrent resultions, this error will be more common.

Turn of Tm1 Architect.

Start Windows file explorer.

Go to folder C:\Users\%username%\AppData\Roaming\Applix\TM1

Open file tm1p.ini in notepad

Remove the line with the text:   SubsetWindowLayoutInfo

Save the file.

Start Tm1 Architect/Tm1Perspective and test again to open the subset editor.

 

 

More information:

TM1 Perspectives subset editor missing when opened on remote desktop system with multiple displays
https://www.ibm.com/support/pages/apar/PM95711

https://www.ibm.com/support/pages/unable-view-all-open-tm1-objects-after-disconnecting-secondary-monitor 

by ·Comments Off on Cognos Controller Client hang when you select accounts

Product:
Cognos Controller 11.0.1200.28

Microsoft Windows 2022 Server

Issue:

Most users get that the Cognos Controller client hang, when they open some selection dialogs. For example – go to Maintain – Account Structure Reports – select codes – and click on the … for the account field, to get a list of all the accounts.  Here the Cognos Controller client hang, and you have to stop cognos controller from the task manager.

Possible Solution:

Do a optimize on the database from inside cognos controller client.

  1. To run the optimization immediately, the system must be in single user mode. Go to Maintain > User > Single Mode and set the system to single mode.
  2. Click Maintain > Database > Optimize. The Optimize Database window opens.
  3. Select the Rebuild Structure Tables check box to rebuild the structure tables.
  4. Select Rebuild Indexes (advanced option).
  5. Click Run

 

Other things you can try to solve the issue are:

Clear the cache in cognos controller

Inside Controller Client program, via Maintain > Special Utilities > Clear Local Cache.

 

Change the cache folder for cognos controller client:

Launch Windows Explorer
4. Open the folder where Controller is installed.

  • Default this is here: C:\Program Files\ibm\IBM Cognos Controller Local Client

5. Open the file “CCR.exe.config” inside Notepad++
6. Search for the entry similar to the following:
<add key=”CacheDir” value=””/>
7. Modify this entry appropriately, for example similar to the following:
<add key=”CacheDir” value=”D:\Controller\Cache” />
8. Save and test

Start Cognos Controller client, and try to open the same account list.

 

There are 3 types of cache folder used by Cognos Controller Client:
(1) Microsoft Internet Explorer cache at C:\Documents and Settings\%USERNAME%\Local Settings\Temporary Internet Files
(2) Microsoft .NET components at C:\Documents and Settings\%username%\Local Settings\Application Data\assembly
(3) Controller user cache files: at C:\Documents and Settings\%appdata%\Application Data\Cognos\ccr\

If there is damage files in this folders, can give strange errors inside Cognos Controller Client program.

 

More information:

Optimize the Database – IBM Documentation

FAQ – What does an ‘internal’ database optimise do, and how often should I run a database optimize?

https://www.ibm.com/support/pages/how-modify-controller-use-different-location-its-temporary-cache-files 

https://www.ibm.com/support/pages/error-systemxml-root-element-missing-inside-multiple-menus-controller-caused-appdata-redirected-unc-path 

https://www.ibm.com/support/pages/explanation-why-cognos-controller-client-side-cache-file-folders-can-be-very-large-and-how-housekeep-them

https://www.ibm.com/support/pages/how-automatically-clear-local-cache-when-closing-controller

https://www.ibm.com/support/pages/controller-microsoft-sql-database-optimisation-and-maintenance-proven-practice-best-practice 

https://www.ibm.com/support/pages/massive-sql-transaction-logs-caused-rebuilding-sql-indexes

https://www.ibm.com/support/pages/reducing-size-controller-database-deleting-period-locking-company-records-table-xacclock

 

You can use Cognos Controller database optimize function to make the following database changes:

  • Remove Period Zero Values – clears the value 0 from selected period tables.
  • Rebuild Structure Tables – which gives quicker access to data.
  • Rebuild Indexes (advanced option) – Rebuilds all indexes in the database to enhance performance and give quicker access to data.
  • Analyze Schema (advanced option) – Reanalyzes the schema for Oracle database.