Search found 143 matches

by Willi
Mon Sep 10, 2018 9:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Aggregations in Rows and Columns do not work
Replies: 6
Views: 740

Re: Aggregations in Rows and Columns do not work

This looks for me like an issue with Feeders. The cells are probably not feeded!?
by Willi
Thu Aug 30, 2018 4:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Order of Cube-Processing
Replies: 10
Views: 841

Re: Order of Cube-Processing

Thx all, that helped me a lot.
by Willi
Wed Aug 29, 2018 6:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Order of Cube-Processing
Replies: 10
Views: 841

Re: Order of Cube-Processing

Okay, got it. Thx. But, to stay with my example. I tested that A is processed before C. So can I say that all C's are processed before another A is selected or is this mixed?
by Willi
Wed Aug 29, 2018 3:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Order of Cube-Processing
Replies: 10
Views: 841

Re: Order of Cube-Processing

I experience a massive, no, a MASSIVE, performance-issue by using a while-loop against a View. So I need to do it via view.
by Willi
Wed Aug 29, 2018 2:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Order of Cube-Processing
Replies: 10
Views: 841

Re: Order of Cube-Processing

Thx for the answer. If TM1 uses the Index-Numbers for the elements it would meet my needs.

at least I need the process to process all C before it changes the A.
by Willi
Wed Aug 29, 2018 2:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Order of Cube-Processing
Replies: 10
Views: 841

Order of Cube-Processing

Hello, i have a cube with 4 Dimensions: Dim1 Dim2 Dim3 Dim4 Now I have a TI wich has to step thru some Elements of Dim1, 1 of Dim2, all of Dim3 and 1 of Dim4. So assuming we have to step thru: Dim1: A1 A2 A3 Dim2: B1 Dim3: C1 C2 C3 C4 Dim4: D1 I created the Subsets on the fly and create the correct ...
by Willi
Tue Aug 21, 2018 8:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form with Perspectives
Replies: 2
Views: 427

Re: Active Form with Perspectives

Hi, thx for the hint it doesn't work.

I have the row-format in Col A, Nothing in Col B the 2 TM1RPTROW in C and D and the value for Zero-Supression in E. But if I use it in Excel I don't get a line but should get around 10. If I disable Zero-Supression it works.
by Willi
Mon Aug 20, 2018 3:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form with Perspectives
Replies: 2
Views: 427

Active Form with Perspectives

Hi, I have an active form with 2 Columns created by TM1RPTROW. And (currently) one column responsible for the Zero-Suppression. Than I have a bunch of columns provided by VIEW or DBRA. This works all fine if I disable Zero-Suppression. If I enable it no row is displayed at all. Only the normal empty...
by Willi
Tue May 15, 2018 6:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form crashes Excel
Replies: 3
Views: 610

Re: Active Form crashes Excel

A little correction: I cannot test it in 10.2.2 because it was realized a complete other way. But I want to confirm that it works in PA 2.0.4 in TM1Web and not in Perspectives. I use now another small cube with the same Dimension to open the AF so I don't need the Attributes for the AF, only to read...
by Willi
Wed May 09, 2018 8:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form crashes Excel
Replies: 3
Views: 610

Re: Active Form crashes Excel

Thx for the answer. Interesting idea. It is not a circular dependency as usual but probably one for "display reason" or "AF opening". But as far as I remember it worked in 10.2.2. I'll see if I can test it.

Yes, it works in TM1Web with the formulas!
by Willi
Wed May 09, 2018 12:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Statement Failed
Replies: 12
Views: 3498

Re: SQL Statement Failed

Wrong.

If you do it syntactically correct and the user has the permission it is correct.

Again: look at the logfile.
by Willi
Wed May 09, 2018 11:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Statement Failed
Replies: 12
Views: 3498

Re: SQL Statement Failed

Hi Willi, I can't get any log because the process is not running. I put the query on the process and press preview to see if it works, but i've checked now and there is no log file of doing that. Do you know where can I find a tutorial that shows me what I can't use on query on TM1? Thanks! Did you...
by Willi
Wed May 09, 2018 11:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Statement Failed
Replies: 12
Views: 3498

Re: SQL Statement Failed

You get a much better error-message in file tm1server.log. Have a look there.

My very first assumption would be the single "<" in one line. The syntax-interpreter of ODBC and TM1 is different to the studio one.
by Willi
Wed May 09, 2018 9:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form crashes Excel
Replies: 3
Views: 610

Active Form crashes Excel

Hello, first of all we use PA 2.0.4 and Excel 2016. I have the following situation with a model created long before I came here: A cube with a couple of dimensions (5). And I want to span an active form over one of these dimensions. Still no problem until here. The Dimension which is used as active ...
by Willi
Fri Mar 23, 2018 5:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web refuses to connect
Replies: 5
Views: 1159

Re: TM1 Web refuses to connect

I don't mean the port of the TM1-Server. I mean the port of the Application-Server. Usual 9510.

And of Course something changed. Otherwise you wouldn'T ask why it isn't working.
by Willi
Thu Mar 22, 2018 9:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web refuses to connect
Replies: 5
Views: 1159

Re: TM1 Web refuses to connect

Is the port for TM1-Applications used from another application?
Do you try to connect from localhost? If not: is the network-config (Firewall, ...) changed?
by Willi
Thu Mar 22, 2018 4:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Empty values of Picklists in TM1WEB
Replies: 0
Views: 673

Empty values of Picklists in TM1WEB

Hi,

in this scenario I'm using Planning Analytics 2.0.4 and TM1Web as frontend. I created a couple of Picklists with a Picklist-Cube. Now I've read in the documentation that all picklists in TM1WEB contains an empty line. But I don't want that. Is it possible to supress this somehow?

best regards
by Willi
Mon Mar 19, 2018 7:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Active Form is returning Zeros even when suppress zero is set to True/1. Please help
Replies: 11
Views: 2221

Re: TM1 Active Form is returning Zeros even when suppress zero is set to True/1. Please help

And additionally did you checked that there is no hidden column in the form wich also references to the TM1RPTVIEW?
by Willi
Fri Mar 16, 2018 2:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX filter on cube values for different dimension
Replies: 6
Views: 1675

Re: MDX filter on cube values for different dimension

My first approach would be: {FILTER( {TM1SUBSETALL( [dim2] )}, [cube1].( [dim1].[([}ElementAttribute_dim2].([dim2].CurrentMember, [}ElementAttributes_dim2].[attr_dim1_elm_name]))], [cube1_measure].[value] ) > 0 )} untestetd especially with the brackets. Idea is to extract the Elementname as Element ...
by Willi
Thu Mar 15, 2018 12:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Active Form is returning Zeros even when suppress zero is set to True/1. Please help
Replies: 11
Views: 2221

Re: TM1 Active Form is returning Zeros even when suppress zero is set to True/1. Please help

And are both colums pretended to be zero (or empty)? If one of them is not zero/empty the line is shown