TM1 Forum

Worked great! Thanks

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 ...

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...

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?

qml wrote:...apply more convoluted logic

This was good for a Monday morning laugh.

Bump?

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 ...

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&...

Thank you

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

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...

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...

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...

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?

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." ...

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))...

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 ...

That will work well. Thanks!

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 forgot to mention that I'm using Report Studio (but I bet you knew that!)