Search found 52 matches
- Wed Mar 21, 2012 8:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Creating a calculation in TI from a cube view
- Replies: 2
- Views: 2156
Re: Creating a calculation in TI from a cube view
Worked great! Thanks
- 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 ...
- 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...
- 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?
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?
- 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
This was good for a Monday morning laugh.qml wrote:...apply more convoluted logic
- Mon Mar 12, 2012 12:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Replication on "Completing Display procedure of Procedure"
- Replies: 7
- Views: 3703
- 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 ...
- 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&...
- Mon Jan 24, 2011 7:43 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
- 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
Thanks
- 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...
- 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...
- 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...
- 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?
- 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." ...
- 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))...
- 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 ...
- 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!
- 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
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
- 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!)