Search found 2816 matches

by tomok
Tue Aug 02, 2022 2:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculation inconsistency after using a DB
Replies: 16
Views: 862

Re: Calculation inconsistency after using a DB

Jorge, the bottom line is this has been the behavior in TM1 since pretty much when the tool was first created. It was initially built for accounting-related apps and this is not normally an issue for budgeting and planning. If you just explain to your users that this is a limitation in the tool, tha...
by tomok
Tue Jun 14, 2022 1:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Chore Disable - Establish when happened
Replies: 2
Views: 366

Re: Chore Disable - Establish when happened

chewza wrote: Tue Jun 14, 2022 12:15 pm Hi Guys

Do you know of a way of establishing when a chore might have been activated/de-acticated?

Many thx
Chris
That event should be recorded in the tm1server.log file.
by tomok
Fri Jun 10, 2022 4:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Reports, Asymmetric Column Headers, Excel and TM1 Web / PAW
Replies: 8
Views: 612

Re: Dynamic Reports, Asymmetric Column Headers, Excel and TM1 Web / PAW

This looks to be what I would expect based on past experience. I am assuming that Actual and Budget are in one dimension, the time periods are in another and the accounts are in yet another. Since you've brought both April YTD and Full Year into the view, both Budget and Actual, as well as a subset ...
by tomok
Wed Jun 01, 2022 4:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder issue... Can someone help
Replies: 9
Views: 2464

Re: Feeder issue... Can someone help

I don't understand the need to feed the Standard Hours measure in the Labor cube. The only issue you'll encounter if you don't feed it would be possible zero-suppression of that measure whenever someone was browsing the Labor cube. It's really easy to get around that problems with a few reporting tr...
by tomok
Mon May 09, 2022 4:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: The AWS Cloud no good, very bad performance
Replies: 13
Views: 1774

Re: The AWS Cloud no good, very bad performance

If the type and number of cores is the same I would suspect hard drive issues, i.e., SAN. Are you sure your drive space is in the same region as your server? Even in cube to cube copies TM1 is going to utilize drive space in the memory temp file. As to Architect, at least from an Admin standpoint, c...
by tomok
Thu Apr 14, 2022 2:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Learning TM1 / Planning Analytics
Replies: 10
Views: 1663

Re: Learning TM1 / Planning Analytics

Although TM1 can be used for a number of things, the true sweet spot for the tool is planning and forecasting (FP&A) and other accounting/financial purposes. In that vein, in only makes sense that a developer that has a keen grasp on the business purpose for FP&A and knows accounting princip...
by tomok
Tue Apr 12, 2022 11:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automated Server Restart - IBM Cloud
Replies: 2
Views: 421

Automated Server Restart - IBM Cloud

Has anyone tried and gotten to work doing an automated server restart on an IBM Cloud TM1 server using a Net Start and Net Stop command? I've tried working on it and I can get the command to execute without any error messages but nothing happens. I'm theorizing that it isn't working either because 1...
by tomok
Mon Apr 04, 2022 11:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: check feeders not working properly in PAL 2.0.9.4
Replies: 5
Views: 986

Re: check feeders not working properly in PAL 2.0.9.4

I concur. I can't remember exactly when check feeders stopped working (we're on the IBM Cloud) but it's been at least a year. Luckily, it's pretty easy to tell when a cell is not fed so it isn't that big of a deal.
by tomok
Tue Nov 30, 2021 2:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Combine ViewExtractSkipConsolidatedStringsSet and ViewExtractSkipCalcsSet
Replies: 2
Views: 11596

Re: Combine ViewExtractSkipConsolidatedStringsSet and ViewExtractSkipCalcsSet

According to the documentation, the behavior you are seeing is the expected outcome. If you skip consolidated values via ViewExtractSkipCalcsSet then you are not going to be able to see any string values from those intersections in your view. The only options I know of would be to 1) not skip consol...
by tomok
Sun Nov 07, 2021 12:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI View Execution vs MDX View
Replies: 13
Views: 29615

Re: TI View Execution vs MDX View

The TI process seems to execute the view as if all dimension are nested on rows. Even though in a TI you don't specify this, it will execute a very large view of data and return the records flattened out. This is the way a TI process works when a cube view is the data source. You get one record for...
by tomok
Wed Nov 03, 2021 6:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CAM ID - How to change LDAP infos without new CAMID
Replies: 2
Views: 5691

Re: CAM ID - How to change LDAP infos without new CAMID

Hi, its not directly a TM1 question, but i hope its ok to post it here.. In our company we use ApacheDS as LDAP for Cognos CA and use CAM security to sso into TM1. Now our company has some changes in the unit structure and we want to correct namings and Unit Numbers in the LDAP, this ends with a ne...
by tomok
Mon Nov 01, 2021 7:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 web security websheet question
Replies: 1
Views: 3035

Re: TM1 web security websheet question

Hello - We have 10 profit centers under 1 dimension. A user logins into TM1 web, goes to applications and opens up a websheet that is saved and is able to see all 10 elements under that dimension. When the user builds that exact same websheet in views, the user is only able to see 1 profit center u...
by tomok
Thu Oct 28, 2021 10:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder took 20 min to save. Can we reduce it?
Replies: 15
Views: 20771

Re: Feeder took 20 min to save. Can we reduce it?

Hi, I am struggling to see how a TI process wouldn't be more logical than a unfed rule in the case of rates? regards, Mark Because the percentages, at whatever level in the dimensions, need to be calculated in real time ? This depends on the purpose of "Rate". If Rate is the result of a c...
by tomok
Mon Aug 09, 2021 12:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Table-Valued function as data source in TI
Replies: 3
Views: 2999

Re: Table-Valued function as data source in TI

Hi, does anyone know whether it's possible to use a table-valued function in the data source of a TI? i.e. select * from tfn_Test1 ('Param1','Param2') At the moment I'm getting an SQL statement failing error I remember I saw stored procedures working, but never tried table-valued functions Thank yo...
by tomok
Tue Jul 20, 2021 11:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CCC scheduled tasks failing on Cloud
Replies: 4
Views: 4308

Re: CCC scheduled tasks failing on Cloud

Not sure how many people are running Cognos Command Center but had our tasks failing since Saturday after IBM carried out some scheduled maintenance. When running the tasks scheduled or manual, in CCC, the 1st step to test TM1 Server connectivity failed with "Task disappeared". Subsequent...
by tomok
Tue Jun 08, 2021 12:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule set value to zero
Replies: 7
Views: 4687

Re: Rule set value to zero

Fed cells are fed and take up memory, regardless of whether or not there is an actual value in the cube that has been fed. I am hesitant to declare it not to be best practice as there may be situations where it is the right answer. However, in most instances I would use STET instead of assigning a z...
by tomok
Tue Jun 01, 2021 5:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Manual Sort Order TI Process
Replies: 4
Views: 4678

Re: Manual Sort Order TI Process

mnasra wrote: Tue Jun 01, 2021 2:34 pm is there a different solution?
Yes. Maintain the dimension through an XDI spreadsheet. This will let you fine tune the order any way you want. AFAIK there is no other way to achieve what you are asking.
by tomok
Tue May 11, 2021 6:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1S Logging Properties - Capturing form publishing
Replies: 2
Views: 2269

Re: TM1S Logging Properties - Capturing form publishing

Not sure what kind of activity you are trying to log but if it is TM1 related, you may try: Thanks. I am trying to capture whenever someone publishes a file in the }Applications folder. We had someone update a form and screwed it up by publishing from an outdated file. Now no one wants to take resp...
by tomok
Tue May 11, 2021 2:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1S Logging Properties - Capturing form publishing
Replies: 2
Views: 2269

TM1S Logging Properties - Capturing form publishing

Does anyone know if it is possible to add parameters to the tm1slog.properties file to log activity in the }Applications folder? If so, what would the parameters be?
by tomok
Thu May 06, 2021 11:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI create view for loading data into
Replies: 3
Views: 2377

Re: TI create view for loading data into

I agree with Wim that we need more information: Where is the data coming from that you are loading into the target cube? If it is a cube, what is the dimensionality of the source and target cubes? What do you mean by "fill in data on consolidated cells"? Please be specific. If you plan on ...