Search found 346 matches
- Fri Jan 26, 2024 4:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15132
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: 85
- Views: 15132
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: 85
- Views: 15132
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: 85
- Views: 15132
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: 85
- Views: 15132
- Sat Jan 06, 2024 2:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15132
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: 85
- Views: 15132
Ultimate Long TM1 quiz
||| 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...
- 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: 2955
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: 1439
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: 1439
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: 9884
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: 667039
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.
- Wed Jun 21, 2023 9:14 am
- Forum: Jedox
- Topic: Any Quality Open Source Olap ??
- Replies: 19
- Views: 667039
Re: Any Quality Open Source Olap ??
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.
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.
- Fri May 12, 2023 4:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Turning on the performance monitor in PAW
- Replies: 6
- Views: 2198
Re: Turning on the performance monitor in PAW
I've checked this now: it does turn perfmon On without server restart (literally PAW adds "PerformanceMonitorOn=T" row in tm1s.cfg file)
- Fri May 12, 2023 3:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Turning on the performance monitor in PAW
- Replies: 6
- Views: 2198
Re: Turning on the performance monitor in PAW
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.
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.
- Mon Jan 16, 2023 6:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Uploading data from source cube to target cube with the source cube bigger in dimensionality
- Replies: 3
- Views: 855
Re: Uploading data from source cube to target cube with the source cube bigger in dimensionality
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"...
- Thu Nov 03, 2022 2:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Old Architect rule editor replaces dashes with hyphens
- Replies: 4
- Views: 827
Re: Old Architect rule editor replaces dashes with hyphens
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...
- Wed Nov 02, 2022 3:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Old Architect rule editor replaces dashes with hyphens
- Replies: 4
- Views: 827
Re: Old Architect rule editor replaces dashes with hyphens
Yes, this happens no matter where the dash is located
- Wed Nov 02, 2022 3:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeders evaluation
- Replies: 8
- Views: 1190
Re: Feeders evaluation
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.
Your "zero" years can be overfed by a feeder like
Code: Select all
['Something'] => ['fiscal_year':'Total years']
And seriously, this "=>['item':'total_cost'];" feeder would confuse me more than your question.
- Wed Nov 02, 2022 2:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Old Architect rule editor replaces dashes with hyphens
- Replies: 4
- Views: 827
Old Architect rule editor replaces dashes with hyphens
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...