TM1 Forum

Correct answer: 0 16 15.

Winner of this week is ardi!
All answers are correct, but ardi was first.

Question #2:

Same rule, Feeder is changed:

MarenC wrote: ↑Tue Jan 09, 2024 1:55 pm While this one was pretty straightforward, I do hope we will be getting the answers to these questions at some point!

Of course! Tomorrow I will announce a winner, correct answer and next question

The first questions are extensions of Yuri Kudryavcev's consolidated feeders questions: https://www.ykud.com/blog/cognos/tm1-cognos/tm1-puzzles-and-diversions-consolidated-feeders/. You must look at them, if not yet. They are great because you can determine whether somebody knows how feeders work or...

||| PLAСE FOR WINNER HERE ^^^ Current question : https://www.tm1forum.com/viewtopic.php?p=83568#p83568 Leaderboard : Adam - 5 MarenC - 4.5 ascheevel - 4.5 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...