TM1 Forum

Now i got your point, the weightings are mostly "1" but it dont help me with an average or? depends on what you want..... like always in live why are the weightings mostly 1 and not allways? Edit: if you mean i could set the weighting to 30 or 31 i think it will not work here, cause i try...

Now i got your point, the weightings are mostly "1" but it dont help me with an average or? depends on what you want..... like always in live why are the weightings mostly 1 and not allways? Edit: if you mean i could set the weighting to 30 or 31 i think it will not work here, cause i try...

Patrick Gr wrote: ↑Mon Sep 09, 2019 2:05 pm From IBM:
"PH05317 SINCE 2.0.6 LOCALIZED NUMBER FORMATTING IN WEBSHEETS IS BROKEN
This is fixed in 2.0.7
Please upgrade"

so, there is a PA Express Version 2.07 - or can u use the normal install files?

for example, i forecast overtime too, but its usually not in so its a 0 most time, but sometimes its not good to get new Employees into the company cause we just have a peak at a day or week, so i add x% overtime to the calculation. Its just one example where i have 0 Values. Other example, Sicknes...

HighKeys wrote: ↑Thu Sep 05, 2019 9:36 am
With no UNDEFVALS but Zeroweightoptimization=F its ignores the 0 Values in the AVG.

because I'm curious - why do you have so many elements with a weighting of 0?

Hello, i already set the Zeroweightoptimization at the server config, but is there no easy way to fill every empty cell with a Zero? Thanks and BR you could write a process to do so. what happens if you dont't use UNDEFVALS? TM1 then doesn't know a difference between a blank cell and a zero that is...

Hi,

you wrote about "Zeroweightoptimization" in the cfg.
What happens if you don't use this and dont't use UNDEFVALS

Just ConsAVG

I tried ist with PA 2.07 and it worked perfect.
I can remember that in older verion the function had a bug - but don't know if 10 or 9somethink

Patrick Gr wrote: ↑Tue Sep 03, 2019 12:04 pm @Orland: there is no 2.0.7 version on Express. I will check with IBM if there is a specific Fix Pack for that.

Let us know what IBM said

forgot:

what happens if you just try ist with one KPI eg "Urlaub %"
maybe it's more easy to investigate the mistake.

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); quick view locks good. btw. i don...

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

Hi Patrick, that's a problem of PA 2.06, if you don't use english as first language in your browser - we had the same issue until we moved to 2.07 https://www-01.ibm.com/support/docview.wss?uid=swg27049229 PH05317 SINCE 2.0.6 LOCALIZED NUMBER FORMATTING IN WEBSHEETS IS BROKEN I've heard that there i...

Take a look here>

https://code.cubewise.com/blog/resolvin ... alculation

Hmmmm Excel without VBA? Could you explain why? I do Excel since years but I'm not the Formula friend, cause VBA brings more performance to it. I see that TM1 isnt be made for VBA use, but Calulating a Year on a daily base would be hard with formulas in a 32 Bit Environment :lol: In TM1 you do the ...

Thanks for your help here! Now i got a better understanding of TM1 and PAX. Sure you are working with PAX and not with TM1 Perspectives? 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...

Hi, don't have the time for an example code - but here are some links and hints Best regards orlando I did not tried yet but I know from where to get MDX code(get from Expression Window). You mean the MDX Expression Window of a subset? Be aware that the MDX produced there might not work in Turbointe...

i think i really don't want to know what you are building there ;-) VBA is not the future - in my opinion. The W of DBRW does not stand for write - you even can write back data with a DBR The DBRW Forumla was the first try of applix to get a better performace of perspectives in a WAN (that's what i ...

Out of pure curiosity, if your user can type in data, why can't he type it directly into a cell with the DBRW formula and press F9? Why in VBA?

Hi,

what did you tried until now to make a dynamic view?
Where will you use this view later?
Where does the parameter come from, to make it dynamic?

Best regards
orlando

Hi kumesh, maybe you should first familiarize yourself with the basic concepts of TM1. I recommend you the pages of IBM https://www-01.ibm.com/support/docview.wss?uid=swg27049091 or this thread: https://www.tm1forum.com/viewtopic.php?f=3&t=14823 You can find more information for beginners by sea...