Search found 1773 matches

by Steve Rowe
Fri Dec 02, 2022 9:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Order set in prolog tab in a view created with MDX is no the order running in datatab
Replies: 5
Views: 184

Re: Order set in prolog tab in a view created with MDX is no the order running in datatab

Is this the same thing as view dimension order though?

OP seems to be talking about element order within the a set being different depending on how the view is accessed?

Since all the other dimensions are pick of single members I can't see why dimension order of view would be impact the set order?
by Steve Rowe
Tue Nov 29, 2022 2:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill down in only a row
Replies: 9
Views: 2781

Re: Drill down in only a row

the Lord giveth and the Lord taketh away Job 1:21 in case you want to know, not the Apple guy. (I had to look this up, just in case anyone gets ideas about my detailed knowledge of scripture!) This kind of thing should be configurable and left in the hands of the user. It's massive assumption and g...
by Steve Rowe
Tue Nov 29, 2022 9:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: question about PAW MDX
Replies: 1
Views: 69

Re: question about PAW MDX

Hi, This should help you figure out what you need. My front end selection cube is dimensioned by user which enables your PAW screens to support multiple users. '{TM1Sort( {[Funding Budget Group].[All], TM1FILTERBYLEVEL( Descendants({ StrToMember("[Funding Budget Group].[" + [Front End Sele...
by Steve Rowe
Wed Nov 23, 2022 8:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prop. Spread on calculated C-Element
Replies: 6
Views: 456

Re: Prop. Spread on calculated C-Element

I don't think proportional spread against a calculated C level element will work, even when the Ns below it are open. In theory there is nothing to stop the engine doing the work, perhaps worth raising with IBM to see if they thinks its a bug but this I would expect to raise an enhancement request f...
by Steve Rowe
Tue Nov 15, 2022 12:36 pm
Forum: Enhancements
Topic: Pafe should always display what is in the cube when doing a retrieve.
Replies: 1
Views: 76071

Re: Pafe should always display what is in the cube when doing a retrieve.

Hi, this RFE has been marked as Not Under Consideration. However the door is slightly open in that if the vote count goes up then it might be reconsidered. Can I ask anyone that feels that the loss of error responses in the DBRW and other reports types is an issue to vote for the RFE please? Cheers,
by Steve Rowe
Tue Nov 15, 2022 12:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives Active Form and O365 removing formulas
Replies: 8
Views: 311

Re: TM1 Perspectives Active Form and O365 removing formulas

Also, and not to be "that guy", but Perspectives is not supported on O365....

Yes it normally works but using O365 introduces risks...
by Steve Rowe
Fri Nov 11, 2022 10:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX view dimension order when used as a source to a TI
Replies: 11
Views: 1212

Re: MDX view dimension order when used as a source to a TI

All well and good if you can dictate the format of the query. If you can control the way the query is constructed then you can control the order of the variables. But what if the content of the MDX statement is unknown and could be anything? How do you deal with that? That's the problem. I can see ...
by Steve Rowe
Thu Nov 10, 2022 10:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX view dimension order when used as a source to a TI
Replies: 11
Views: 1212

Re: MDX view dimension order when used as a source to a TI

Your use case must be rather different from mine, I'm not having issues reaching a stable soluton. I build my views using this form. sMDXToUse='SELECT {%sMDX5%} ON 0, %sFilterHead% NONEMPTY( CROSSJOIN(%sMDX1%, CROSSJOIN(%sMDX2%, CROSSJOIN(%sMDX3%, %sMDX4%))), {%sMDX5%} %sFIlterEnd% ) ON 1 FROM [Plan...
by Steve Rowe
Wed Nov 09, 2022 4:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX view dimension order when used as a source to a TI
Replies: 11
Views: 1212

Re: MDX view dimension order when used as a source to a TI

We all need better dreams!

It was mentioned recently, by Lotsaram I think, but I'm sure he'll notice this post...
by Steve Rowe
Wed Nov 09, 2022 2:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX view dimension order when used as a source to a TI
Replies: 11
Views: 1212

MDX view dimension order when used as a source to a TI

Hi, This issue has been fixed since 2.0.9.10. https://www.ibm.com/support/pages/apar/PH24729 and https://www.ibm.com/support/pages/node/6489261 If you had a stable solution prior to 2.0.9.10 and upgrade to 2.0.9.10 or higher then you will probably need to make changes to any TIs that use MDX views a...
by Steve Rowe
Tue Nov 08, 2022 9:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 and informatica cloud
Replies: 3
Views: 907

Re: TM1 and informatica cloud

Moved and bumped as originally posted in the jobs forum....
by Steve Rowe
Fri Oct 21, 2022 8:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using Expand Function to make Variable Dynamic in TI
Replies: 8
Views: 553

Re: Using Expand Function to make Variable Dynamic in TI

I think you are asking about how to collect the row headers so that you can use them as measure values to write the data to cube. The problem with expand is that you can only use it on the right hand side and so it is "only" useful for reading variable values. If we had something like it o...
by Steve Rowe
Wed Oct 19, 2022 1:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: rule line error runtime error :circular reference, evaluation stack
Replies: 11
Views: 659

Re: rule line error runtime error :circular reference, evaluation stack

wrt to a circular reference one thing that isn't always obvious until it happens to you the first time is that you need to consider rules and consolidations in the dimension together. To illustrate this with a silly example. Say your period dimension has Jan rolling into Year. and you write a rule [...
by Steve Rowe
Mon Oct 17, 2022 4:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RPTROW issue
Replies: 8
Views: 897

Re: TM1RPTROW issue

Hi, Its pretty challenging to debug MDX without the system in front of you. I'd suggest the following. 1. Set up a distinct cell that holds the Excel formula that is delivering the MDX statement. i.e. This piece ="{FILTER({FILTER({FILTER({TM1FILTERBYLEVEL({TM1DRILLDOWNMEMBER({[OUTLETS].["&...
by Steve Rowe
Fri Oct 14, 2022 3:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Deleted objects resurfacing
Replies: 2
Views: 414

Re: Deleted objects resurfacing

How are you deleteing the objects?
If direct from the file system is the DB running while you do the delete?
by Steve Rowe
Wed Oct 12, 2022 10:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 right question
Replies: 4
Views: 361

Re: TM1 right question

Looks like you are trying to do a spread, i.e. data entry at the C level. Judging from the error message the user doesn't have write access at the C level intersections in the view. So I'd say recheck the security model but make sure you consider that they need WRITE access at the C level to do so. ...
by Steve Rowe
Wed Oct 12, 2022 9:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cases where MDX is a better alternative to cube rules
Replies: 9
Views: 774

Re: Cases where MDX is a better alternative to cube rules

I'll play devil’s advocate in the interest of keeping the debate going! No criticism intended! My use case for MDX views, wouldn’t be for calculations but using picklists to deliver advanced filtering of records / cells and PAW wide synchronisation across user sessions. Picklists are a great way of ...
by Steve Rowe
Tue Oct 11, 2022 2:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 PAW - Exploration view - Insert calcul on 2 dimensions
Replies: 22
Views: 1382

Re: TM1 PAW - Exploration view - Insert calcul on 2 dimensions

If you have a calculated measure of sufficent complexity that you need to make a MDX view, wouldn't you write a ruled measure or consolidation instead? Put aside the relative complexity of a rule versus MDX and the level of rights you need to on the DB to undetake this activity. I'm genuinely intere...
by Steve Rowe
Thu Oct 06, 2022 4:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: rule save time wait problem
Replies: 8
Views: 957

Re: rule save time wait problem

Quick and dirty for testing new rules etc could be to remove nearly all the data, except that which you need to proove out rule changes. Depends if are you trying to solve "I need to get these rules written and tested" or "How to improve the compile time of the rules" As others h...
by Steve Rowe
Wed Oct 05, 2022 9:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Exploration - Missing Page Filters/Dimension Bar
Replies: 1
Views: 318

Re: PAW Exploration - Missing Page Filters/Dimension Bar

Is the Show / Hide Overview getting pressed / set at some point during this?

This looks like a downward pointing ">" , you'll need to have the exploration widget selected to see it. Pressing it should show the view headers again.