TM1 Forum

Are the users able to manually open 2 tabs at the same time? If not it could be the hidetabbar option is set in either the config file or the }clientsettings cube. Thanks for pointing me in the right direction here. I have managed to resolve it by specifying this config parameter explicitly & s...

Hi Declan,
They are able to open two different browser tabs, and navigate to say sheet 1 and sheet2 respectively. Is that what you meant?
Thanks
Kaz

Hi everyone, We are evaluating Planning Analytics Local 2.0.9.1 in test environment, while our production is on 2.0.4. We have links to various websheets that are accessed by action buttons. In production, upon clicking an action button, the websheet is opened in a new tab within TM1Web in the same ...

Hello Kaz, Setting a c-level rule, as you do for PNL00000Q, does not impact higher-lever consolidations, in this case PNL00000H or PNL00000D, as those also consolidate leaf-level elements. You’ll need to use ConsolidateChildren , but this gets messy. Thanks for the response. I was hoping to avoid C...

Hi guys, I have a multi level hierarchy in my management account dimension, as shown in Subset with hierarchy image. 1.2 Subset with hierarchy.png PNL00000Q should be a calculation of ABS( PNL000068 ) - ( PNL000067). This is working okay. However the parents of PNL00000Q,PNL00000D and PNL00000H leve...

Although not free, Pulse (by Cubewise) has all monitoring, deployment and change control tools you need. Also, their Arc product is good for writing code (snippets, auto-indent etc). Likewise, I used Rest API for hot promotion, although not extensively. Furthermore, I have got a few PowerShell scri...

Sure, I see you want skipcheck and feedstrings to be the first statements to avoid any doubts.

But this was an odd scenario.

My normal structure is
#notes

skipcheck;
feedstrings;

rules ;

feeders;

Thanks
kaz

Hi everyone, I am on Planning Analytics Local, 2.04, and use Architect. I ran into a weird scenario yesterday where rules in one of my TM1 cubes replicated themselves. My rules looked like below; #create date #notes skipcheck; feedstrings; rule 1 ; rule 2 ; rule 3 ; feeders; feeder for rule 1 ; feed...

Thanks Wim and Tom. @Wim, I tried setting order of the elements, but they get blown away as soon as the overnight process loads data and re-assign children to their respective parents. @Tom, my data loading process has multiple processes. I am adding Current, New Work, and Not Used as children of Al...

Hi everyone, I am trying to sort the following consolidations ; Capex-projects-consol-sorting-issue.png I want 'All Not Used' to be listed before 'All New Work', and I have tried variations of DimensionSortOrder function but I am not having any luck, certainly I am doing something incorrect. What's ...

Thanks, I shall give it a shot.
So, basically, absence of tm1 tag wouldn't make a difference?

Hi everyone, I am working on configuring integrated login for TM1 Web, Planning Analytic v2.04 using https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_tm1_ug_configuring_sso_with_spnego.html from IBM. I was at the step 4 where yo update server.xml fi...

At first sight, this should work. Can you create a view in the cube viewer with the alias turned on and your MDX expression, then Active form to Excel and see if that works ? Hi Wim, That does work. Following is the MDX for RptRow, where {AR} is a hidden worksheet containing static element names fr...

Here are the functions and the MDX that i am using TM1RPTROW($C$8,"FinancePlan:Line of Business","",,"Code and Description",0,$D$22) TM1RPTView in cell $c$8: TM1RPTVIEW("FinancePlan:Line of Business:Plan:1", 0, TM1RPTTITLE("FinancePlan:Line of Business:Sy...

tried TM1Rpt and tried specifying the alias in Alias parameter after Subset parameters. Didn't work. Then you didn't do it right. It's best to use the function editor in Excel (click on the little fx icon next to the formula bar). This keeps you from specifying the parameters in the wrong order. Hi...

Hi Wim

I did, and indeed tried TM1Rpt and tried specifying the alias in Alias parameter after Subset parameters. Didn't work.

Perhaps it's worth mentioning that my Active Form skills are quite limited.

Hi guys,

Is it possible to display element alias when using MDX within TM1RptRow in Active Forms? I know that we are able to display aliases when using a subset within TM1RptRow instead of MDX.

I actually did a full upgrade to 10.2.2 FP7 yesterday. I didn't see this at all. This was after a fresh install of Office 2016 as well. Are you sure you've installed the correct version? You haven't installed the 64 bit version of the client on a 32 bit version of excel? Jim. Thanks for the reply J...

jim wood wrote: ↑Thu Aug 31, 2017 11:32 am What's the macro security level set to? I'm not certain it could have something to do with it but it's something worth looking at,

Jim.

Hi Jim,

It is set to Enable all macros. Thanks
Kaz