TM1 Forum

Correct answer : Firstly, feeder from numeric "Salary" do not know that Job Type is changed, and feeder will not re-fire after Job type is changed. Secondly, "Trace feeders" do not check if target cell is fed. It checks if current feeder written in rule, with current data (like ...

Anyone? 1 question is still without answer

OK! But why does "Trace cell" show "fed" with my feeder?

Correct answer : SKIPCHECK; ['Current Salary'] = N: IF(DIMIX('JobType', !JobType) = DIMIX('JobType', DB('Employee', !organization, !EmployeeList, !Year, !Version, 'Job Type')), DB('Employee', !organization, !EmployeeList, !Year, !Version, !Employee), 0); Using DIMIXes is better than comparing alias...

Yes Ordinary subset-based picklist "subset:JobType:All leaves', where "All leaves" has alias enabled

Correct answer : 31 0 0. A is not feeding anything, being consolidated. It's children B and C both feed A1. Winner of this week is ascheevel ! Question #6: We are done with feeders, well done! Now new set of questions. There is "Employee" cube with employees list, their job types and sala...

Correct answer : CubeUnload before re-saving new feeder - ok, it looks like I'm a looser for whom it does not work on 80% environments... I've also found one customer where it works on 2.0.9.12. There are different interfaces for it: manually in Architect, CubeUnload TI function, tm1py function cub...

That is not correct. CubeUnload stopped clearing feeders in one of the PA versions (I think it was in PA 2.0.0-2.0.4 period, but might be wrong. Does anybody know?). There are different ways to purge feeders, all should be listed in the most detailed answer edit: It was very hard to decide, but you ...

Correct answer : 31 16 15 - if rule was just resaved; 31 0 0 - if rule was written from scratch. If a cell is fed once, it will retain being fed even if we delete the whole "FEEDERS;" section. Server will not run through the whole cube looking for fed cells. Winner of this week are aschee...

No additional actions were announced Just changed the feeder and saved the rule

- Correct answer : 0 16 15. Again Winner of this week is ardi ! Again :). As a reminder: the best answer is correct, most detailed and most independent one. Nobody has described how feeders work when consolidated element is set on the left side of feeder and why numbers have not changed. If there wa...

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=83452#p83452 Leaderboard : ascheevel - 3.5 MarenC - 3.5 ardi - 3 Adam - 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!