Search found 54 matches

by MarenC
Mon Dec 02, 2019 4:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: @= in active sheet formula
Replies: 1
Views: 208

@= in active sheet formula

Hi,

We are seeing some strange behaviour in excel active forms. When we put in a formula and use a function it is inserting an @ symbol, so for example we see,

=@TM1RPTROW($E$10,.....)

Anyone come across this before?

Maren
by MarenC
Fri Nov 22, 2019 12:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Rule question
Replies: 2
Views: 487

Re: Cube Rule question

Hi being a newbie I would create a view of the Input Cube for the relevant week and to get the dimension I would do a cellgets to the Project in the input cube,

so cellputn(vValue, ReportCube, vVersion, vName, CellgetS(inputcube, vVersion….'Project'), vWeek….);

Maren
by MarenC
Wed Nov 06, 2019 5:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteProcess not working
Replies: 6
Views: 647

Re: ExecuteProcess not working

Hi,

Your data source is a cube view and if this includes consolidations, you will need to ensure it doesn't skip consolidated values.

see ViewExtractSkipCalcsSet

Maren
by MarenC
Wed Nov 06, 2019 10:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Max Value
Replies: 13
Views: 8692

Re: Max Value

Hi, Rolling consolidations just seem like a maintenance nightmare, so parked that idea for now. The TI process seems reasonable, i.e. you could have a nightly process to update the current period. But have gone with the following for now: 1. Create a new numeric attribute called Index Period, which ...
by MarenC
Tue Nov 05, 2019 11:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1.Server sf_Delete and sf_Rename failed
Replies: 17
Views: 5454

Re: TM1.Server sf_Delete and sf_Rename failed

Hi all, I have noticed in the data folder that there are 2 .cub files for the same cube (employees), one is employees.cub and the other is employees.cub$ The employees.cub$ is at a later date than the employees.cub. I also have a few error messages (repeated each day), as follows (there are more but...
by MarenC
Fri Nov 01, 2019 5:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Understanding Feeders
Replies: 11
Views: 2393

Re: Understanding Feeders

Hi gTonkin,

believe it or not but I have just spent the last hour reading that very article!

I have also added it to my favourites bar for future reference

Maren
by MarenC
Fri Nov 01, 2019 5:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Understanding Feeders
Replies: 11
Views: 2393

Re: Understanding Feeders

Hi Wim,

updated the first link, the max issue is still under consideration!

Maren
by MarenC
Fri Nov 01, 2019 5:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What difference do hierarchies make
Replies: 2
Views: 2478

Re: What difference do hierarchies make

The one cube approach did make more sense, thanks for your advice Wim
by MarenC
Fri Nov 01, 2019 4:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Understanding Feeders
Replies: 11
Views: 2393

Re: Understanding Feeders

Thanks Wim, that helps!
by MarenC
Fri Nov 01, 2019 4:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Understanding Feeders
Replies: 11
Views: 2393

Re: Understanding Feeders

I have read the following, "The feeder area identifies a component of a rules-derived value. When this component contains a non-zero value, a placeholder is fed to cells containing the rules-calculated value identified on the right-hand side of the statement. This placeholder alerts the TM1 consolid...
by MarenC
Fri Nov 01, 2019 3:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Understanding Feeders
Replies: 11
Views: 2393

Re: Understanding Feeders

Thanks for the response Wim, so what you are saying is there is no difference between method 1 and 2 because the determination of how many cells are fed would by looking at the right side of the feeder statement? So in the following example method 1 would be feeding less than method 2: Method1: ['Sa...
by MarenC
Fri Nov 01, 2019 3:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Understanding Feeders
Replies: 11
Views: 2393

Understanding Feeders

Hi, Just want to try and get my head around feeders and start with basics! Imagine I have 2 cubes, CubeA and CubeB and I want to feed from CubeA to CubeB. The rule in CubeB is as follows: ['Sales Amount'] = n: DB('CubeA', !Year, !Product, 'New Items', 'Sales'); Would I better in the feeder doing (me...
by MarenC
Thu Oct 31, 2019 9:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to use both HIERARCHIZE and TM1 sort together in MDX
Replies: 4
Views: 4732

Re: How to use both HIERARCHIZE and TM1 sort together in MDX

Hi,

from a technical point of view why do I need the curly braces around All but not around the TM1Sort?

{[All]} + TM1SORT( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [DimName] )}, 0)}, DESC)

Union({[All]}, TM1SORT( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [DimName] )}, 0)}, DESC))

Maren
by MarenC
Wed Oct 30, 2019 11:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What difference do hierarchies make
Replies: 2
Views: 2478

What difference do hierarchies make

Hi, I am trying to understand how hierarchies change the approach to building TM1 models. I have an example of the 'old way' and wondered if in the world of hierarchies this old way was, well, old! So in the example I have 2 cubes, CubeA and CubeB. They have matching dimension except in CubeB there ...
by MarenC
Tue Oct 29, 2019 11:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Max Value
Replies: 13
Views: 8692

Re: Max Value

Hi, does anyone know how to get the maximum value by looking at the previous, say 24 months, from another cube? So for example in cube A January 2019, how to get the maximum value for the previous 24 months (from January 2019) from Cube B (which includes months dimension too). In other words how can...
by MarenC
Fri Oct 25, 2019 11:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User Entries and Web Sheets break with Server Reboot
Replies: 3
Views: 3753

Re: User Entries and Web Sheets break with Server Reboot

Juts along the lines of Xavier, Do you have multiple TM1 instances, other than the financial model? Do you have action buttons on the websheets? If so have you checked that they all point to the financial model server. I had an issue where one of the action buttons on the websheet, which simply reca...
by MarenC
Mon Oct 21, 2019 9:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Message Log WARN
Replies: 3
Views: 3781

Re: Message Log WARN

Hi Wim,

Does this only appear when the source is ODBC?

I tried testing with a csv data source, had 3 rows in the source, made the middle row blank and did dimensionelementinsert and when I ran the process it just inserted the 2 populated rows and ignored the blank one?

Maren
by MarenC
Mon Oct 21, 2019 8:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Message Log WARN
Replies: 3
Views: 3781

Message Log WARN

Hi,

I am seeing some WARN messages in the message log, the message reads:

TM1.Dimension Object Name is Blank

It appears this error is against a process which ODBC's to a sql database

Does anyone have any ideas what could trigger this error?

Maren
by MarenC
Fri Oct 18, 2019 1:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Difference between TI Text and Cube View
Replies: 8
Views: 4085

Re: Difference between TI Text and Cube View

I updated to use sleep instead, thanks.

Maren
by MarenC
Fri Oct 18, 2019 10:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Difference between TI Text and Cube View
Replies: 8
Views: 4085

Re: Difference between TI Text and Cube View

have you tried putting in a wait to allow PS to finish?
That was the problem. I had ExecuteCommand(vCmd, 0), I changed to ExecuteCommand(vCmd, 1) and it worked ok

Thank you very much

Maren