TM1 Forum

Thanks guys! I appreciate your opinion and input! You do raise a fair and valid question and it now has me second guessing. I inherited this server instance. However, I am also rebuilding it and can change things. In our current, we have 4 reporting cubes and all four of them have rules and it takes...

Hi all - it's been awhile since I have posted on here, but I was wondering what the best way is to feed a reporting cube that is using [ ] =N: and [ ] =C: to pull over data? We have a "Forecast Intermediate" cube where all of our rules are and calculations are handled. It pulls data from v...

Thanks Lotsaram. That is correct. All of the code was directly from IBM and is VBA sitting in an Excel module. It works just as it is, however, since we are automating, we need to pass along credentials without the pop up box. The only way we know how to do this is as I showed by commenting out the ...

Thanks Brian. Do you know if you can use TM1SystemServerConnectWithCAMNamespace with security mode 5 ? We had tried that but when it got to it, it didn't error, it didn't do anything. We were using API then, too, because it seemed that every time we looked, we were told we needed to call TM1APIIniti...

HI Tomak - actually, we aren't familiar with how to do it without API. We are very much open to it but just haven't been able to figure it out without. The only stumbling block we have is the log in. We can't have a pop up box when it's done automatically, thus, need to pass along credentials or fig...

Hi all, A teammate and I have been working on connecting to TM1 via VBA code and are stumped with one thing that I am hoping someone can help with? We've done quite a bit of searching online and in this forum but must be missing something in our understanding. We have the code working but what we ha...

By george, I think I may have gotten it!! This appears to be working! :D :D I changed my last section (the section in purple) to the following: ['Inventory'] =C: IF(DTYPE('Products',!Products) @= 'C' & DTYPE('WeekDayWeekly',!WeekDayWeekly) @= 'C', ConsolidateChildren('WeekDayWeekly') \ Consolida...

Hi everyone, I've been reading through everything I can find on ConsolidatedAvg in the forum and have tried all sorts of different things and I just can't seem to get this to work how I need so I am breaking down and submitting a question to the forum :) I have tried changing the order of my dimensi...

Thanks a lot, guys! You know what, on my spreadsheet, I changed the DBRW to DBR and it, indeed, took care of the flakiness! :) Very happy about that. I had to think through what cells were pointing to what, etc. and then changed only some of them - not all. There are some that are getting this odd b...

Thanks a lot lotsaram! I have gotten tied up with some other things but will most definitely circle around back to this and try your recommendations. I just wanted to say thanks and will post more later.

Hi everyone, I was wondering if anyone else has run into this issue? Several of us end-users are getting this and I am not sure why. I can open my slice that has been saved and it will be fine but the moment I click F9, then I get either *KEY_ERR or #VALUE. However, if I click in the cell and then c...

I can't really divide my spreadsheet and need to have them together. My pc and server are both on the same network so I am thinking my view must be improperly constructed? I did just do a slice originally and then simply added a control tab to my spreadsheet and then tweaked the formula to read to t...

I don't have access to the server, so I can't try that option :( In regards to my PC, I have an Intel Core i5-4300U CPU @ 1.90GHz 2.50 GHz with 8GB or RAM (7.90 GB usable) and a 64-bit OS. Is that underpowered? (this is getting off topic of the original post). When you say "redesign your DBRW s...

Hi - I've tried it on both. Typically, when I reopen Excel it will change to Automatic even though it was on Manual prior to saving and closing. Really, it doesn't matter what I change an Excel setting to because the tm1p.xla seems to be changing or overriding it

Hi everyone, I did a search and wasn't successful on finding an answer so thought I would submit a question. I have several spreadsheets that use a lot of DBRW formula's and as a result, the calc speed has been horrible. Thus, I went into Excel Options --> Advanced --> and scrolled down to "Ena...