Skip navigation.
spilling the beans
sharing and organising free knowledge for BI implementations with a focus on IBM Cognos TM1.

Can we display string elements along with number fields during consolidations(qtr, year-to-date, month-to-date)

Scenario: I have three rows (rows include string fields and number(dollar) fields) that contain data from Jan, Feb and Mar. I would like my rows to be displayed for the following scenarios along with the string fields:


TM1 9.4

TM1 9.4 was released last week.
It can be found on Cognos support site for registered customers.
tm1tutorials.com has a powerpoint from Ben Hill describing the features. And olapforums users have an ongoing discussion about the fitness of that new release.


monitor rules and processes

admins
| | | | |

Changing a rule or process in TM1 does not show up in the logs.
That is fine as long as you are the only Power User able to tinker with these objects.
Unfortunately, it can get out of hand pretty quickly as more power users join the party and make changes that might impact other departments data.


monitoring users logins

admins
|

a quick way to monitor users login/logout on your system is to log the STATUS value (i.e. ACTIVE or blank) from the }ClientProperties cube.


SQL statement failed

Hi, I need some help.
I have a Tm1 process that reads from an access database query.
This was still working about a week ago. No I am getting the following error message. SQL statement failed.
Any ideas on what can cause this and why it happens?