Search found 58 matches
- Mon Jan 10, 2011 3:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: check for an empty view
- Replies: 6
- Views: 3755
Re: check for an empty view
no such command, but be careful using the top level consolidations of all dims to do that. If you use a weighting other than 1 on any elements it could give you a false report... well, I have hard coded there the top level element for some dimensions and some elements passed as parameters for other...
- Mon Jan 10, 2011 1:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: check for an empty view
- Replies: 6
- Views: 3755
Re: check for an empty view
Some lateral thinking ... You could assign the view as a data source to a generic process that has skip blanks ON but skip calcs and rules OFF (make sure the process has sufficient variables to accommodate all cubes in the model). On the prolog initialise a counter with a value of zero. On the data...
- Mon Jan 10, 2011 11:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: check for an empty view
- Replies: 6
- Views: 3755
check for an empty view
Hi guys,
I had a brief look in the reference guide and in the forum but I found nothing about it.
Is there a command to check if a view is empty?
I had a brief look in the reference guide and in the forum but I found nothing about it.
Is there a command to check if a view is empty?
- Fri Dec 17, 2010 4:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: rebuilding an Excel sheet via TI
- Replies: 3
- Views: 2508
Re: rebuilding an Excel sheet via TI
same as 'rebuild sheet' option of the TM1 button I can put in an excel to rebuild it.tomok wrote:Define "rebuild".
- Fri Dec 17, 2010 3:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: rebuilding an Excel sheet via TI
- Replies: 3
- Views: 2508
rebuilding an Excel sheet via TI
Hi guys,
I was wondering,
is it possible to rebuild an excel sheet via a TI?
I was wondering,
is it possible to rebuild an excel sheet via a TI?
- Mon Dec 06, 2010 4:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: fast question about MDX
- Replies: 2
- Views: 1962
Re: fast question about MDX
it worked.
thanks for the help.
thanks for the help.
- Wed Dec 01, 2010 3:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: fast question about MDX
- Replies: 2
- Views: 1962
fast question about MDX
hi,
is it possible to create an MDX passing a variable containing the dimension name instead of a dimension name?
I mean:
SubSetCreateByMDX(vSub,'{TM1FILTERBYLEVEL({TM1SUBSETALL([Variable] )},0)}');
instead of
SubSetCreateByMDX(vSub,'{TM1FILTERBYLEVEL({TM1SUBSETALL([DimensionName] )},0)}');
is it possible to create an MDX passing a variable containing the dimension name instead of a dimension name?
I mean:
SubSetCreateByMDX(vSub,'{TM1FILTERBYLEVEL({TM1SUBSETALL([Variable] )},0)}');
instead of
SubSetCreateByMDX(vSub,'{TM1FILTERBYLEVEL({TM1SUBSETALL([DimensionName] )},0)}');
- Tue Oct 19, 2010 9:27 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: error never seen on service start up
- Replies: 2
- Views: 2377
error never seen on service start up
Hi All, I restored a backup on a server and I got this error on restarting the service: http://img188.imageshack.us/img188/7950/erroref.jpg Uploaded with ImageShack.us I tried to: delete the logs put another backup on put the last working backup put down and up the admin service switch off and on th...
- Tue Oct 19, 2010 9:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: unknown error -191
- Replies: 2
- Views: 3040
Re: unknown error -191
if the value <> 0 then cellputproportionalspread else "execute an equal spread". Why not just do as you've suggested? If the value is <> 0 then use the cellputproportionalspread, if not, your else conditon would include the steps to put an equal value in each child. Query for the number o...
- Fri Oct 15, 2010 3:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: unknown error -191
- Replies: 2
- Views: 3040
unknown error -191
Hi, i searched the forum and I saw that there is already a topic about it, but it is not exactly the same situation. The fact is that spreading a value on a member that is a parent and it was 0 previously issue this error. Apparently it is because there is no mix under the parent to spread a value p...
- Wed Oct 13, 2010 10:26 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: spread via excel
- Replies: 0
- Views: 1194
spread via excel
Hi, I have another issue. I want to put a spread function in an excel worksheet. I cannot use the the spread menu of the TM1 form because the dimensions on which I want to spread are in point of view and not only in row or column. I found that there is a TI function called CELLPUTPROPORTIONALSPREAD ...
- Tue Oct 12, 2010 7:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: excel and subsets
- Replies: 9
- Views: 4977
Re: excel and subsets
Hi Stingo, I think your problem is a simple one. Provided the text in cell "E14" is indeed a valid public subset in the APS_Product_GM dimension then all that you need to do is REBUILD rather than RECALCULATE the worksheet. (Alt+F9 rather than Shift+F9) If that's not it then I as well as ...
- Mon Oct 11, 2010 5:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: excel and subsets
- Replies: 9
- Views: 4977
Re: excel and subsets
What I want is to keep the TM1RPTROW as it is but to put parametric the name of the subset. Just replace the "Cheese" in your TM1RPTROW formula with a cell reference to where "Cheese" has been chosen through a drop-down created via data validation in Excel. ok, this is what was ...
- Mon Oct 11, 2010 9:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: excel and subsets
- Replies: 9
- Views: 4977
Re: excel and subsets
thanks guys, I'll try and I'll let you know. RGDS stefano EDIT: I'm checking the reference guide and it is saying this: Do not use cell references as arguments with the SUBNM function. Cell references prevent the function from correctly calling and launching the Subset Editor when you double-click ...
- Mon Oct 11, 2010 8:36 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: excel and subsets
- Replies: 9
- Views: 4977
Re: excel and subsets
thanks guys, I'll try and I'll let you know. RGDS stefano EDIT: I'm checking the reference guide and it is saying this: Do not use cell references as arguments with the SUBNM function. Cell references prevent the function from correctly calling and launching the Subset Editor when you double-click t...
- Wed Oct 06, 2010 8:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: excel and subsets
- Replies: 9
- Views: 4977
excel and subsets
Hi All, I have this problem. I want to build a worksheet with a view containing a dimension in row (in my example the product dimension). this dimension has to show me just the lev 0 members that are contained in a subset (in my case the product category) choosed by the user via a drop down menu. th...
- Mon Sep 27, 2010 3:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ViewZeroOut question about current month
- Replies: 1
- Views: 1945
Re: ViewZeroOut question about current month
hi,
you can create a subset for the month dimension containing just the month indicated by the variable and create the zeroout view based on that subset.
you can create a subset for the month dimension containing just the month indicated by the variable and create the zeroout view based on that subset.
- Mon Sep 27, 2010 2:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: creating a formula based on current member
- Replies: 1
- Views: 1680
creating a formula based on current member
Hi All, I'm translating a system from SAP BPC to TM1, I have to create a formula like: [VL_0000000_D]= if currentmember = DB('APS_PnL',!APS_Entity,'VL_0000000',!APS_RPTCurrency,!APS_DataSrc,!APS_Scenario,!APS_Time,!APS_Account_PnL), DB('APS_PnL',!APS_Entity,!APS_Product_PnL,!APS_RPTCurrency,!APS_Dat...