Search found 334 matches
- Fri Feb 23, 2024 4:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8370
Re: Ultimate Long TM1 quiz
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 ...
- Thu Feb 22, 2024 6:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8370
Re: Ultimate Long TM1 quiz
Anyone? 1 question is still without answer
- Sun Feb 18, 2024 12:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8370
Re: Ultimate Long TM1 quiz
OK! But why does "Trace cell" show "fed" with my feeder?
- Sat Feb 17, 2024 8:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8370
Re: Ultimate Long TM1 quiz
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...
- Tue Feb 13, 2024 7:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8370
Re: Ultimate Long TM1 quiz
Yes Ordinary subset-based picklist "subset:JobType:All leaves', where "All leaves" has alias enabled
- Mon Feb 12, 2024 6:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8370
Re: Ultimate Long TM1 quiz
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...
- Fri Feb 02, 2024 6:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8370
Re: Ultimate Long TM1 quiz
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...
- Tue Jan 30, 2024 6:38 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8370
Re: Ultimate Long TM1 quiz
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 ...
- Fri Jan 26, 2024 4:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8370
Re: Ultimate Long TM1 quiz
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...
- Sat Jan 20, 2024 1:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8370
Re: Ultimate Long TM1 quiz
No additional actions were announced Just changed the feeder and saved the rule
- Fri Jan 19, 2024 5:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8370
Re: Ultimate Long TM1 quiz
- 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...
- Sat Jan 13, 2024 2:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8370
Re: Ultimate Long TM1 quiz
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:
Winner of this week is ardi!
All answers are correct, but ardi was first.
Question #2:
Same rule, Feeder is changed:
- Thu Jan 11, 2024 7:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8370
- Sat Jan 06, 2024 2:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8370
Re: Ultimate Long TM1 quiz
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...
- Sat Jan 06, 2024 2:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8370
Ultimate Long TM1 quiz
||| 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...
- Wed Oct 18, 2023 11:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Pafe/PAW View - Auto Spread at Consolidated Level
- Replies: 2
- Views: 2909
Re: Pafe/PAW View - Auto Spread at Consolidated Level
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...
- Tue Aug 29, 2023 2:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }ClientGroups cube not in sync. with Cognos
- Replies: 11
- Views: 1412
Re: }ClientGroups cube not in sync. with Cognos
Are you sure you've copied the whole script?
As Wim said, it's declared in the beginning using WITH clause:
As Wim said, it's declared in the beginning using WITH clause:
Code: Select all
with groups_unwrapped (parent_group_id, child_group_id, lvl)
as .....
- Fri Aug 25, 2023 7:38 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }ClientGroups cube not in sync. with Cognos
- Replies: 11
- Views: 1412
Re: }ClientGroups cube not in sync. with Cognos
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/
- Fri Jul 07, 2023 6:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Identify All References to Cube
- Replies: 7
- Views: 9841
Re: Identify All References to Cube
Hi,
There is a very old but working parser written on perl: https://www.bihints.com/graphing_tm1_data_flow
There is a very old but working parser written on perl: https://www.bihints.com/graphing_tm1_data_flow
- Fri Jun 30, 2023 7:36 am
- Forum: Jedox
- Topic: Any Quality Open Source Olap ??
- Replies: 19
- Views: 663250
Re: Any Quality Open Source Olap ??
Wow many thanks!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.