Search found 97 matches

by HighKeys
Wed Sep 04, 2019 2:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ConsolidatedAvg & UNDEFVALS
Replies: 21
Views: 4534

Re: ConsolidatedAvg & UNDEFVALS

Hey,

if i dont use both, it ignores the 0 Values.

if i had a table like

0
0
5
0
0
5

The AVG is 5
by HighKeys
Wed Sep 04, 2019 2:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ConsolidatedAvg & UNDEFVALS
Replies: 21
Views: 4534

Re: ConsolidatedAvg & UNDEFVALS

Hi Orlando, thanks! the elements in the Rule like "Urlaub %" i just calulate this line with them. It works as i can see correctly, if i add "0" to every blank cell.... what i dont understand, is it really needed that i add for everyday manually a 0 into the cell for the whole year to get it right or...
by HighKeys
Wed Sep 04, 2019 10:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ConsolidatedAvg & UNDEFVALS
Replies: 21
Views: 4534

Re: ConsolidatedAvg & UNDEFVALS

Hello The AVG rule: [{'Urlaub %', 'Abwesenheit % Bedarf (Stand rMA)', 'Bezahlte Abwesenheit %', 'Meeting %', 'Unproduktive Anwesenheit %', 'Stundenkonto %', 'Krank %'}] = N:STET; C:ConsolidatedAvg(1,'', !Tag, !Version, !MA-Pool, !Kennzahlen Personalbedarf-Planung); I get scared. Just for testing and...
by HighKeys
Wed Sep 04, 2019 7:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ConsolidatedAvg & UNDEFVALS
Replies: 21
Views: 4534

ConsolidatedAvg & UNDEFVALS

Hello friends, i have to ask you something again.... Since 2 days i try to get ConsolidatedAvg working for me to replace a old "Counter/Ghost" logic to delete all helper elements. I changed the server cfg, to add Zeroweightoptimization to the file, then i added "UNDEFVALS" to the Cube rule, there is...
by HighKeys
Thu Aug 29, 2019 12:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: [Excel] Writeback in Cube with VBA
Replies: 9
Views: 10928

Re: [Excel] Writeback in Cube with VBA

Hey, yea I'm the only warrior :D :lol: For working with TM1 you do not need Visual Studio. You can get good results with Turbointegrator, Excel (without VBA), Rules and TM1Web. But you have to study, study and study Hmmmm Excel without VBA? Could you explain why? I do Excel since years but I'm not t...
by HighKeys
Thu Aug 29, 2019 10:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: [Excel] Writeback in Cube with VBA
Replies: 9
Views: 10928

Re: [Excel] Writeback in Cube with VBA

Hi, Thanks for your help here! Now i got a better understanding of TM1 and PAX. Sorry for sometime my noobish questions, i started in a new Company and we use TM1 here, it is my fristtime where i have to handle it, i have to administrate this tool and i think its very powerful, but at the moment not...
by HighKeys
Thu Aug 29, 2019 7:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: [Excel] Writeback in Cube with VBA
Replies: 9
Views: 10928

Re: [Excel] Writeback in Cube with VBA

Its a bigger calculation with % Keys, its my Forecasting Tool, now i wanna try to impement an Autoupload to TM1. @Alan, i thought DB S stands for "String" and DB SS "Send String". I also thought DB RW stands for "Read Write" i can try it again with DBS(S) but last time i got a wrong type error. What...
by HighKeys
Thu Aug 29, 2019 7:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: [Excel] Writeback in Cube with VBA
Replies: 9
Views: 10928

[Excel] Writeback in Cube with VBA

Hello friends,

i was woundering about if it is possible to writeback a Value to a cube using VBA?

If i use Application.Run with the DBRW Formula it just gets the value and i can't change.

Any hint for me?

Thanks and BR
by HighKeys
Tue Aug 27, 2019 11:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Formula just read value without xml setting changes
Replies: 3
Views: 8395

Re: Excel Formula just read value without xml setting changes

Hello,

Thanks, the websheet is really nice for that!


BTW if someone searching the same later, if you Disable Events you can write in the cell without writeback :)


BR
by HighKeys
Tue Aug 27, 2019 11:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: [Excel] TM1 Get Value from Cube VBA
Replies: 2
Views: 7419

Re: [Excel] TM1 Get Value from Cube VBA

Hello, thanks! i was too deep in the formula when i coded this... Function GetNumberFromTM1(Server As String, Cube As String, ParamArray arg() As Variant) As Long ReDim Z(UBound(arg())) For i = 0 To UBound(arg()) Z(i) = arg(i) Next i send = Chr(34) & "DBR" & Chr(34) & "," & Chr(34) & Server & ":" & ...
by HighKeys
Tue Aug 27, 2019 8:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: [Excel] TM1 Get Value from Cube VBA
Replies: 2
Views: 7419

[Excel] TM1 Get Value from Cube VBA

Hello, how can i get a value from a cube in VBA? I tried to send the DBR Formula via "Application.Run" but it seems not to work. Function GetNumberFromTM1(Server As String, Cube As String, ParamArray arg() As Variant) As Long ReDim Z(UBound(arg())) For i = 0 To UBound(arg()) Z(i) = arg(i) Next i sen...
by HighKeys
Fri Aug 23, 2019 10:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Formula just read value without xml setting changes
Replies: 3
Views: 8395

Re: Excel Formula just read value without xml setting changes

Hello,

Thanks for your input, i will check this option!


Thanks!
BR
by HighKeys
Thu Aug 22, 2019 5:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Formula just read value without xml setting changes
Replies: 3
Views: 8395

Excel Formula just read value without xml setting changes

Hello friends, as i can read here every formula can write back in the cubes https://www.ibm.com/support/knowledgecenter/de/SSHM9K_10.2.2/com.ibm.swg.ba.cognos.ug_cxr.10.2.2.doc/c_cxr_worksheetfunctionoverview.html In some sheets i just need to read the value and dont wanna write back (i have to chan...
by HighKeys
Wed Aug 21, 2019 10:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Connect with TM1p.xla & VBA
Replies: 6
Views: 3603

Re: Connect with TM1p.xla & VBA

Hey Orlando! Thanks for your help! Works great now! if someone is interested, here is the code: Private Sub workbook_open() Application.Calculation = xlCalculationManual Dim oAddIN As AddIn, vAd As String On Error GoTo Fehler For Each oAddIN In Application.AddIns If oAddIN.Name = "tm1p.xla" Then If ...
by HighKeys
Tue Aug 20, 2019 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Connect with TM1p.xla & VBA
Replies: 6
Views: 3603

Re: Connect with TM1p.xla & VBA

Hi!

works perfect, thank you so much!!

So one last thing to do, how i could check if TM1 is already connected to a Server?

Thanks!
by HighKeys
Fri Aug 16, 2019 8:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Connect with TM1p.xla & VBA
Replies: 6
Views: 3603

Re: Connect with TM1p.xla & VBA

Hello, thanks for your help! But could you help me also how i can check if the Ribbon is loaded or not? I Tried this Function bCommandBarExists(sCmdBarName As String) As Boolean Dim bCbExists As Boolean Dim cb As CommandBar bCbExists = False For Each cb In Application.CommandBars Debug.Print cb.Name...
by HighKeys
Tue Aug 13, 2019 9:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Connect with TM1p.xla & VBA
Replies: 6
Views: 3603

Connect with TM1p.xla & VBA

Hello, i'm new with TM1 and i try to get a auto connection in some sheets for TM1. So i added in the Open Event a check to find out if the user already loaded the plugin, if not then the addon should be loaded. After that i call the COnnection call from the dll, now you can select a server and press...