Search found 122 matches

by orlando
Thu Mar 26, 2020 7:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: List of subsets created
Replies: 8
Views: 1918

Re: List of subsets created

I can’t remember the exact version when it was introduced but for quite a while now there have been standard system dimensions that list all of the subsets for each dim and views for each cube. The dimension name would be }subsets_<yourdimname> and it just contains all of the subset names as elemen...
by orlando
Fri Mar 06, 2020 12:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: A way to find used Views
Replies: 3
Views: 1062

Re: A way to find used Views

is there a smart way to find this out? i am more drastic. i make a backup of the views, delete the ones we (controller and me) think are no longer needed. if someone screams, we copy the view back. but of course we only do this for the public views and not the private ones of the users, the users t...
by orlando
Wed Feb 26, 2020 10:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hyperlink in TM1 Web
Replies: 5
Views: 655

Re: Hyperlink in TM1 Web

TimeTq wrote:
Tue Feb 25, 2020 10:07 am
Hi, I want to create a hyperlink from xlsm file to another xlsm file ( both of them on server).

Hi,

out of pure curiosity - why are you not using an "action button"?

best regards
orlando
by orlando
Wed Feb 26, 2020 10:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pass a parameter to SQL stored procedure
Replies: 1
Views: 281

Re: Pass a parameter to SQL stored procedure

## EPILOG ## sSP = 'EXEC [TM1ODBC].[data].[start_end_time] @load_id = Select pLoadNumber'; Hi, there is no parameter in your query - the complete query is in quotation marks. try this: sSP = 'EXEC [TM1ODBC].[data].[start_end_time] @load_id = Select ' | pLoadNumber; i'm not that used to sql at the m...
by orlando
Tue Feb 25, 2020 9:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web White Blank Page
Replies: 10
Views: 1463

Re: TM1 Web White Blank Page

I have a additional Question, before i had this issue, we dont see the mask to select a server in tm1web, now i can switch between our dev and prod enviroment, is there a way to change it? thanks for your help! Hi, the TM1web config is your friend for that. In ..PATH_TO_YOUR_INSTALL\webapps\tm1web\...
by orlando
Thu Feb 13, 2020 1:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Looping in a Daily Dim
Replies: 8
Views: 608

Re: Looping in a Daily Dim

forgot to set the counter in the inner loops back to 1 thats why the loop just run once. Not the last time you will forget this..... Very bad code, i think its totally vs best practice but it works. :) may be, but the code works - that is the most important thing. now you can start with the optimiz...
by orlando
Thu Feb 13, 2020 12:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Looping in a Daily Dim
Replies: 8
Views: 608

Re: Looping in a Daily Dim

HighKeys wrote:
Thu Feb 13, 2020 12:29 pm

Just the while(c <= d); loops correct. Is it not the correct syntax?

Thanks and KR
think so, could you post the original code?
by orlando
Thu Feb 13, 2020 8:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Looping in a Daily Dim
Replies: 8
Views: 608

Re: Looping in a Daily Dim

Hi, a short idea what do to. You have finalise by yourself. Take a look here https://www.bihints.com/book/export/html/68 this gives you all N elements of a parent {TM1FILTERBYLEVEL({DESCENDANTS(Product.[Customer Lending]) }, 0)} https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba...
by orlando
Wed Dec 11, 2019 12:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Region Problem After PA Migration
Replies: 7
Views: 918

Re: Region Problem After PA Migration

Jorge Rachid wrote:
Wed Dec 11, 2019 11:59 am

As I have said, when we change the region configuration of windows it works.
We had region problems with TM1Web with PA 2.06 - with PA 2.08 everythink works fine
Which PA Version are u using?
Did you ask the IBM Helpdesk?
by orlando
Mon Sep 30, 2019 8:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy cell level comments from old to new cube
Replies: 2
Views: 1274

Re: Copy cell level comments from old to new cube

Hi, these comments are stored in an extra cube "}CellAnnotations_YourCubeName" Your new cube needs also these cube (easiest way to create: make a comment ;-) ) If you have it you can try to copy the values into the new copy - never done that myself. I see one problem: in the values, stored in the an...
by orlando
Fri Sep 27, 2019 1:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Continuous time link to discrete time dimension
Replies: 8
Views: 1658

Re: Continuous time link to discrete time dimension

Hi Orlando: Just wandering , if there is a fast way / automatic way to do this process, maybe by using rules or formulas? TimeDimension.png Hi, yep - there is. Rule or TI. If you're using a Rule - you don't have to worry about new elements somethink like that should work - https://exploringtm1.com/...
by orlando
Fri Sep 27, 2019 7:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Continuous time link to discrete time dimension
Replies: 8
Views: 1658

Re: Continuous time link to discrete time dimension

WayneBo wrote:
Fri Sep 27, 2019 6:42 am
Hi Orlando:


Is there a way that I can mass edit the attributes of a dimension after the dimension been created already?

How does you dimension look like? Could you post a screenshot?
by orlando
Fri Sep 27, 2019 5:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Continuous time link to discrete time dimension
Replies: 8
Views: 1658

Re: Continuous time link to discrete time dimension

Hi All: But I don't know how do I transfer the calculated daily budget number ( which on month level in a discrete time in budget cube) to the daily occupancy cube ( which is using the continuous time on daily level) in the relevant (correct) month and year. Hi, here is my very fast idea - early in...
by orlando
Thu Sep 26, 2019 9:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Action button - call Macro
Replies: 10
Views: 4714

Re: Tm1 Action button - call Macro

kavitha2002 wrote:
Thu Sep 26, 2019 6:24 am
Yes I know. Thanks.

Is there other possibility of calling the macro via Tm1 Action button?
Nope. I don't think there is any supported way to do so.
by orlando
Mon Sep 16, 2019 7:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ConsolidatedAvg & UNDEFVALS
Replies: 21
Views: 3370

Re: ConsolidatedAvg & UNDEFVALS

Done and works perfect!
Hurray!
now i can remove much of this help elements in the cubes here (ghost counter elements to get average) :D
if you now get rid of the VBA and put the application on the web, then this is also something for the future ;)
Thanks my friend!
you're welcome
by orlando
Thu Sep 12, 2019 9:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ConsolidatedAvg & UNDEFVALS
Replies: 21
Views: 3370

Re: ConsolidatedAvg & UNDEFVALS

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 to build ...
by orlando
Thu Sep 12, 2019 9:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ConsolidatedAvg & UNDEFVALS
Replies: 21
Views: 3370

Re: ConsolidatedAvg & UNDEFVALS

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 to build ...
by orlando
Mon Sep 09, 2019 2:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted
Replies: 7
Views: 1751

Re: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted

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?
by orlando
Thu Sep 05, 2019 11:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ConsolidatedAvg & UNDEFVALS
Replies: 21
Views: 3370

Re: ConsolidatedAvg & UNDEFVALS

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...
by orlando
Thu Sep 05, 2019 9:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ConsolidatedAvg & UNDEFVALS
Replies: 21
Views: 3370

Re: ConsolidatedAvg & UNDEFVALS

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?