TM1 Forum

||| PLAСE FOR WINNER HERE ^^^ Current question : https://www.tm1forum.com/viewtopic.php?p=83545#p83545 Leaderboard : MarenC - 4.5 ascheevel - 4.5 Adam - 4 ardi - 3 EP_explorer - 1 Hello Everybody! I have collected a huge amount of TM1 questions while interviewing people. I want to share them with th...

Hi, There are many options: Use CellSecurity to make consolidated cells 'READ" Use ElementSecurity to make consolidate elements 'READ" (better than point "1", because Elementsecurity is pre calculated on SecurityRefresh, and CellSecurity is re calculated each time view is recalcu...

Are you sure you've copied the whole script?
As Wim said, it's declared in the beginning using WITH clause:

Hi, You need to to search client*group relationships in Cognos Content Store database. Here is the tables list: https://cogknowhow.com/t/cognos-content-store-database-tables-description/906 Here is an example of SQL query: https://www.ykud.com/blog/cognos/cognos-content-store-security-overview-in-sql/

Hi,

There is a very old but working parser written on perl: https://www.bihints.com/graphing_tm1_data_flow

lotsaram wrote: ↑Thu Jun 29, 2023 2:01 pm Well there's tinyolap https://tinyolap.com/
But this is single user in-process. Although the project bio talks about xP&A use cases I can't think of any real planning use case which is viable without multi-user and a security model.

Wow many thanks!

Hello everybody!

10 years have passed, so I want to revive this topic.
Is there any open-source OLAP with planning capabilities now? Jedox has become commercial, leaving the last open-source 5.1 version in 2015.

I've checked this now: it does turn perfmon On without server restart (literally PAW adds "PerformanceMonitorOn=T" row in tm1s.cfg file)

Hi

Generally speaking you can, but you need to go roundabout ways: in Administration, server configuration, you can change some tm1s.cfg parameters including PerformanceMonitorOn. PerformanceMonitorOn is dynamic, so this will turn it on immediately.

If you are using the Architect TI process constructor and not writing code from scratch, you should select "Element" role only for the variables matching your target cube's elements + Data. The other variables (which are in source cube and are not in target cube) should be "Other"...

The dash in the first screenshot is an Em Dash - MS Word is generally to blame and converts dashes to em dashes via auto correct as you type. Someone then copies these to Excel or elsewhere then into TM1 and you have an issue. Yes Sherlock, it was exactly like you've described :) The rux file, equa...

Yes, this happens no matter where the dash is located

Hi,

Your "zero" years can be overfed by a feeder like and feed further other zero cells.

And seriously, this "=>['item':'total_cost'];" feeder would confuse me more than your question.

Hello everybody! I have noticed a strange behavior of the old rule editor: if I try to use object names with dashes (–, code 150), it works fine for the first time. But if I reopen it, the rule editor replaces them with hyphens (-, code 45). When I try to change something (eg add a comment) and save...

It's containerized Apache:
https://www.ibm.com/support/pages/plann ... iated-logs

Hi,

This is a PAW window. Is your PAW running, do you have access to it? Check if you can use subset editor in PAW directly.
Also check if PAW address is added to trusted/local intranet in your internet options

Hi, this can appear when you have a mismatch in quick report and cube structures. Possible reasons: You have several dimensions in rows/columns, and their order is broken (eg you have accounts and months in rows (in this order), but the labels aer in different order (September, Revenue)) Sandbox doe...

I've dragged random dimensions (Version and Cost center) to colors just to show how it works.

This depends on what you want to be split to different lines and different columns. Note that This should be different dimensions

You should use the "couleur" fields. One of them is for columns, one is for lines (my French is too bad)

Hi,

You need "Color" section in "Fields" tab for this.