TM1 Forum

Hi dr.nybble

Fantastic, thanks for that...it worked!

Cheers
Terri

Hi codingCPA I'm glad I found your post as I'm having the exact same issue with an installation of TM1 & PAW on the same MS Server 2016 vm. I have all the sample TM1 servers installed on Planning Analytics 2.0.3, but only have the Planning Sample TM1 Server running, & using its HTTPPortNumbe...

Hi lotsaram Thanks for your suggestion, but I had tried the hyperlink in the websheet menu & I get a "reference not valid" error. The URL link is correct as it works when I click on it in Perspectives so this isn't the issue. I'll try your suggestion of storing the URL in a cube...I ha...

Hi Tomok

Yes, I understand that As I mentioned, the (2) users are connecting to this vm (TM1) server via RDP & just using TM1Web. They don't have a client installation on their local machine, nor are they using TM1Web on their machine.

Cheers
Terri

Hi Alan Ok, so I've changed the account that runs all the TM1 services over to an administrator account of the TM1 server. I've also created this user account in TM1 (Cognos Express) as it's not using AD. The E:\ is a partitioned drive on the TM1 server, & this account has full access to both C:...

Hi Alan Thanks for your speedy response. Yes, all files/programs are on the TM1 server. Adobe is installed & the .bat file runs perfectly to open the .pdf when I double click on it within Windows Explorer. It could possibly be an account security issue so I'll check that out. Many thanks Terri

Hi I'm trying to compile a TI process to run a batch file that will open Adobe Reader & a particular file name as saved in the .bat file. If I run the .bat file directly, it all works correctly. Trying to run it via the TI process, it just seems to hang if I have a wait argument of 1, or says th...

Hi Wim Great, thanks so much for that. I noticed that it then creates the subset with no elements, so using your suggestion of SubsetGetSize, I was able to then delete the subset if it was empty. My final code looks like.... SubsetCreatebyMDX('subsetname','{HIERARCHIZE({TM1SORT({FILTER({FILTER({TM1F...

Hi I'm building a Project dim & creating the subsets in the Epilog tab. Some subsets filters by the Customer code of the project/s & if the project has an active status. So my code looks like.... SubsetCreatebyMDX('subsetname','{HIERARCHIZE({TM1SORT({FILTER({FILTER({TM1FILTERBYLEVEL({TM1DRIL...

Hi Alan Thanks for all that info, much appreciated! I hadn't seen that TM1 treats strings as numeric if not in the last dim...very handy to know, & I'm glad I wasn't around in pre-alias days, that sounds horrendous! :o I'll consider the export/import solution, I don't think the data size is too ...

Hi I've just found some elements in a dimension that were created as a string type rather than simple. It's not a measure dimension nor the last dimension in the order in cubes, so it's strange that it hasn't seemed to cause any issues to date. I've tried various ways to change the type, via a TI pr...

Hi lotsaram

Yes, all files are definitely .xlsx & no macros.

Cheers
Terri

Hi all After upgrading to Excel 2013 with CX 10.2.1 FP3, Excel seems to be working fine & I can upload/update my websheets to TM1Web, but now when I try to go into the properties of an application item (right click on item in Applications Folder in Architect/Perspectives) it opens up the new TM1...

Great, thanks so much JamiseBondi, I was experiencing the same issue in CX 10.2.1.3 when I had a tab name including the "|" character.

Hi Tomok Yes, I understand that it can only reference a subset or MDX. Sorry, I should have included that the subset argument cell ($D$11) is configured to be blank if I want to use the MDX argument, & vice versa. Is it impossible to reference an alias when using the MDX argument? Many thanks Te...

Hi I hope this is ok that I'm posting in addition someone else's post, but I'm wondering if you can reference an alias for the MDXStatement argument of the TM1RPTROW. I am using a subset for one result of the TM1RPTROW, and using the MDXStatement for the other result of the TM1RPTROW. =TM1RPTROW($B$...

Ok, I worked it out! I have added in the code if(AMT01<>0 % AMT02<>0 % AMT03<>0 % AMT04<>0......) after the extract of all values & before the asciioutput line, it will export all month values for only those natural account numbers that have a value in any AMTxx column <> 0. Thanks for all your ...

Thanks for all your posts....I've tried some solutions & they don't seem to be working (could be because of my lack of knowledge though)! Just to clarify, I need an asciioutput txt file, comma delimited, that gives me a line for each natural account number, along with Jul Amt, Aug Amt, Sep Amt.....

Hi We have a TI process that currently extracts all natural accounts entries over each month for a year from a cube view. Currently the extract includes all values, no matter if they are zero or not. I am trying to get the output file that includes a line for the natural account for each month &...

Great, thanks so much Alan.

Regards
Terri