Skip navigation.
bihints.com
spilling the beans
 contents | community | links | site map | FAQ | contact us
sharing and organising free knowledge for BI implementations with a focus on IBM Cognos TM1.

SQL statement failed

Submitted by Dobby on Tue, 2008-06-24 10:07.

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?


» read more | Dobby's blog | 3 comments | write to author

Beam me up Scotty: 3D Animated TM1 Data Flow

admins
Submitted by admin on Wed, 2008-05-21 12:45. | |

Explore the structure of your TM1 system through the Skyrails 3D interface:


» read more | login or register to post comments | write to author | 3 attachments

the fallacy of blb files

developers
Submitted by admin on Fri, 2008-05-16 10:08. | |

TM1 system files with the blb extension, incorrectly referenced as "cube formatting" files (admin guide p.35) are actually "rule formatting" files for the "standard" rules editor (prior to 9.1).


» read more | login or register to post comments | write to author

The case against single children

admins
Submitted by admin on Fri, 2008-04-04 08:28. |

I came across hierarchies holding single children.
While creating a consolidation over only 1 element might make sense in some hierarchies, some people just use consolidations as an alternative to aliases.


» read more | login or register to post comments | write to author

Updating SQL directly with Tm1

Submitted by Dobby on Thu, 2008-03-06 11:56.

Is it possible to directly update SQL tables using Tm1? If yes, what steps do I have to follow?


» Dobby's blog | 3 comments | write to author