Search found 52 matches

by ChrisF79
Wed Mar 21, 2012 7:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating a calculation in TI from a cube view
Replies: 2
Views: 2156

Creating a calculation in TI from a cube view

Sorry for the remedial nature of the question but it's been a while since I've done this. I'm building a cube with a different cube's view as the source. My measures I'm exporting are Qty and Price. In the new cube, I'm going to load commission rate which is simply price * 0.05. How do I write that ...
by ChrisF79
Fri Mar 16, 2012 1:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there an easy way to convert a dynamic subset to static?
Replies: 15
Views: 13767

Is there an easy way to convert a dynamic subset to static?

We have some problems going on due to dynamic subsets causing table locks, etc. That's not the point of the post though. The point is, how can we easily convert dynamic subsets to static ones? I've read about the SubsetCreateByMDX function but that creates the dynamic subset. Any way of making it st...
by ChrisF79
Mon Mar 12, 2012 2:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Replication on "Completing Display procedure of Procedure"
Replies: 7
Views: 3703

Re: Replication on "Completing Display procedure of Procedur

TM1Top just shows it working. We haven't seen any big changes in the log files.

As for not trusting replications, I agree that they're pretty finicky. However, if you have servers in multiple locations, what do you do to move data around?
by ChrisF79
Mon Mar 12, 2012 12:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot convert field number 14, value "@None" to a real numb
Replies: 5
Views: 8057

Re: Cannot convert field number 14, value "@None" to a real

qml wrote:...apply more convoluted logic
This was good for a Monday morning laugh.
by ChrisF79
Mon Mar 05, 2012 7:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Replication on "Completing Display procedure of Procedure"
Replies: 7
Views: 3703

Replication on "Completing Display procedure of Procedure"

I manually replicate a cube from a remote location to our main TM1 server. The particular cube and dimensions takes me around 15 minutes to do manually. I set the cube to sync and built a chore that replicates just that one cube but it takes 40 minutes now. One other thing that's strange is that in ...
by ChrisF79
Mon Mar 28, 2011 8:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server error regarding feeders and cube dates
Replies: 0
Views: 2051

TM1 server error regarding feeders and cube dates

Greetings: We're running 9.5.1 and recently had our server crash at night. Just today, I attempted to restart the server and the restart was nearly complete when the service completely stopped. A quick check of the log file showed the following error: Invalid feeder file detected for cube "QAD&...
by ChrisF79
Mon Jan 24, 2011 7:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI function to find location of a string within a string?
Replies: 2
Views: 2296

TI function to find location of a string within a string?

What's the function that does this? I have an attribute in the form of DISTRIBUTOR - SALES REP. I need to find the location of the " - " so I can use SUBST to break out the Distributor and Rep. I just can't remember the function.

Thanks
by ChrisF79
Wed Dec 22, 2010 1:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Expression in Active Form question
Replies: 8
Views: 5035

Re: MDX Expression in Active Form question

Chris You can't use the TM1SubsetBasis() function in an active form! You need to specify the member of the Customer dimension that you wish to drill down on. I just got it working with the TM1SubsetBasis. I'm not doing any drilling, just refreshing the list of customers based on criteria the user o...
by ChrisF79
Tue Dec 21, 2010 8:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Expression in Active Form question
Replies: 8
Views: 5035

Re: MDX Expression in Active Form question

Unfortunately, pasting that into Excel as the last argument in TM1RPTROW is giving me an excel error saying my formula is invalid. Did you bother to look at the proper syntax and sequencing of the arguments in the TM1RPTROW formula before trying or did you just blindly paste it in as the last argum...
by ChrisF79
Tue Dec 21, 2010 7:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Expression in Active Form question
Replies: 8
Views: 5035

Re: MDX Expression in Active Form question

That's not working out unfortunately. The expression recorder is giving me this as an MDX Statement: {FILTER({TM1DRILLDOWNMEMBER({TM1SubsetBasis()},ALL,RECURSIVE)},[Customers].[Last Pay Days]=1007.000000)} There should be 2 customers. Unfortunately, pasting that into Excel as the last argument in TM...
by ChrisF79
Tue Dec 21, 2010 6:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Expression in Active Form question
Replies: 8
Views: 5035

Re: MDX Expression in Active Form question

I see now that it's definitely not the {AR} part of the formula so now my questions become, how do I generate the MDX that I want to limit on two attributes and then where do I implement it in the formula?
by ChrisF79
Tue Dec 21, 2010 6:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Expression in Active Form question
Replies: 8
Views: 5035

MDX Expression in Active Form question

I have a customers dimension and there are two attributes--one for days since they last paid and one for days since they last had a sale. What I'm trying to do is make an active form that says, "Give me all customers where they haven't paid for 90 days but have had a sale in the last 30." ...
by ChrisF79
Thu Dec 16, 2010 9:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question regarding active forms
Replies: 4
Views: 2918

Re: Question regarding active forms

Strange, but I'm trying to calculate the number of days between two dates and getting an error in the process. The code is: IF ( (vlastsale @<> 'NO LAST SALE') % (vlastpay @<> 'NO LAST PAY') ); LastSaleDays = DAYS360( NOW() - DATEVALUE(vlastsale)); LastPayDays = DAYS360(NOW() - DATEVALUE(vlastsale))...
by ChrisF79
Wed Dec 15, 2010 2:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question regarding active forms
Replies: 4
Views: 2918

Question regarding active forms

I just made a spreadsheet using active forms that pulls our customers that have outstanding balances for AP. The problem is, the list is about 6000 customers long. I'd like to make the list filtered in some way for accounts that are past due. I have an attribute on the customer dimension that tells ...
by ChrisF79
Sat Nov 20, 2010 3:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Making a private dimension subset public
Replies: 6
Views: 5463

Re: Making a private dimension subset public

That will work well. Thanks!
by ChrisF79
Fri Nov 19, 2010 7:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Making a private dimension subset public
Replies: 6
Views: 5463

Making a private dimension subset public

Greetings:

I have a coworker that is not an admin and made a subset in one of the dimensions. He saved that subset and asked me to make it public. I'd like to but I don't see it. Is there a way I can make a user's subset public?

Thanks
by ChrisF79
Wed Nov 03, 2010 8:50 pm
Forum: Cognos Planning and BI
Topic: Working with one level of hierarchy data
Replies: 1
Views: 3822

Re: Working with one level of hierarchy data

I forgot to mention that I'm using Report Studio (but I bet you knew that!)