Search found 190 matches

by kenship
Tue Sep 20, 2022 1:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOutput Elements in One Dimension Only
Replies: 21
Views: 1927

Re: ASCIIOutput Elements in One Dimension Only

Noted with thanks. Actually I skipped the sString since I only need the project code extracted. The IF check is added at the beginning of the each section before resetting the iTimeCount to 1. The output result is the same so I am sure I'm not missing anything. Kenneth I get it, I'll implement it. K...
by kenship
Mon Sep 19, 2022 7:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOutput Elements in One Dimension Only
Replies: 21
Views: 1927

Re: ASCIIOutput Elements in One Dimension Only

I get it, I'll implement it.

Kenneth
Wim Gielis wrote: Mon Sep 19, 2022 5:27 pm I would add a couple of:

If ( nFlag = 0);

To avoid processing useless loops.
If you already know that nFlag <> 0, why bother with other loops ?
by kenship
Mon Sep 19, 2022 5:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOutput Elements in One Dimension Only
Replies: 21
Views: 1927

Re: ASCIIOutput Elements in One Dimension Only

I have implemented yours solution and modified to expand qualifying criteria. In my case the process loop each project for if there's value based on: Current year + each month + Revenue/Expense + Actuals/Budget ledger Previous year + Full Year + Revenue/Expense + Actuals Only the project is extracte...
by kenship
Fri Sep 16, 2022 12:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOutput Elements in One Dimension Only
Replies: 21
Views: 1927

Re: ASCIIOutput Elements in One Dimension Only

Thanks to all, it's indeed a plentiful of suggestions. I did have the Active flag on mind before going to the forum. I was hoping there's a way that I can output the view that gives me exactly what I want (I don't mind the extra columns) but I think this feature can only be a wishlist. MDX and flag ...
by kenship
Thu Sep 15, 2022 11:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOutput Elements in One Dimension Only
Replies: 21
Views: 1927

Re: ASCIIOutput Elements in One Dimension Only

Thanks. I was hoping there's an easy way to use TI to extract something very similar to a snap shot, with many horizontal nested columns but first column giving me project without repeating it (which is why I nested the columns). But I do appreciate your offer. Kenneth As I have understood your requ...
by kenship
Thu Sep 15, 2022 11:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOutput Elements in One Dimension Only
Replies: 21
Views: 1927

Re: ASCIIOutput Elements in One Dimension Only

I don't need the other values at all. The whole exercise is to output a list of project that is active, as defined by whether there's any value based on expenditure or revenue in any month, in actuals or budget ledger. Doing a cube view is just super simple, if I take a snap shot then my project lis...
by kenship
Thu Sep 15, 2022 8:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOutput Elements in One Dimension Only
Replies: 21
Views: 1927

Re: ASCIIOutput Elements in One Dimension Only

Apologize for confusion. My regular AsciiOutput looks like this: 456 All Dpt Exp P01 Actuals 5 456 All Dpt Rev P01 Actuals -6 456 All Dpt Exp P01 Budget 5 456 All Dpt Rev P01 Budget -5 456 All Dpt Exp P02 Actuals 4 456 All Dpt Rev P02 Actuals -3 456 All Dpt Exp P02 Budget 5 456 All Dpt Rev P02 Budge...
by kenship
Thu Sep 15, 2022 7:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOutput Elements in One Dimension Only
Replies: 21
Views: 1927

Re: ASCIIOutput Elements in One Dimension Only

Consolidation for Dep is not the issue but consolidating Exp and Rev could be if there're offsetting negatives. My example shows Revenues in positive but in my data it's negative. More than this, I would need to nest the columns with 12 months and 2 ledgers. That means my extraction file would have ...
by kenship
Thu Sep 15, 2022 5:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOutput Elements in One Dimension Only
Replies: 21
Views: 1927

Re: ASCIIOutput Elements in One Dimension Only

Hi Wim, thanks for replying. I noticed my original post wasn't the most intuitive in asking the question. I have now edited what I want to achieve better. Kenneth You have more than 180 posts here, I would assume that this task is not so difficult. In the view that is the data source to the process,...
by kenship
Thu Sep 15, 2022 2:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOutput Elements in One Dimension Only
Replies: 21
Views: 1927

ASCIIOutput Elements in One Dimension Only

Hi all, I use AsciiOutput to export cube data without problem. I have a new requirement that I need to export only the element of one dimension. The element is short listed based on the cube view. This is a sample before zero suppression: Project Dept Expenditure Revenue 123 A 0 0 456 B 10 5 789 C 1...
by kenship
Tue Sep 06, 2022 2:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Powershell Snd-MailMessage Fail to Attach File
Replies: 16
Views: 779

Re: Powershell Snd-MailMessage Fail to Attach File

Thanks! I'll probably stick with what I have for now. We wanna keep things as simple as possible since we don't have the admin. right to the Windows server and we can only work with whatever we can in Architect. Kenneth When I was testing -Attachments, it's all run from Prolog. I was testing to atta...
by kenship
Tue Sep 06, 2022 2:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Powershell Snd-MailMessage Fail to Attach File
Replies: 16
Views: 779

Re: Powershell Snd-MailMessage Fail to Attach File

When I was testing -Attachments, it's all run from Prolog. I was testing to attach a file already in the data directory. Now it's run from Epilog, attaching a file in the data directory. There's no asciiOutput run at all. Kenneth The command has to be run in Epilog not Prolog. Not sure why because t...
by kenship
Tue Sep 06, 2022 1:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Powershell Snd-MailMessage Fail to Attach File
Replies: 16
Views: 779

Re: Powershell Snd-MailMessage Fail to Attach File

After trying a few things I got the answer.

The command has to be run in Epilog not Prolog. Not sure why because the working TI has been in Prolog all the time.

Also the attachment operator should be: -Attachments ' | ' \ " ' |pAttachment| '\"

Now it's working.
by kenship
Sun Sep 04, 2022 7:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Powershell Snd-MailMessage Fail to Attach File
Replies: 16
Views: 779

Re: Powershell Snd-MailMessage Fail to Attach File

The file to be attached is actually on the same drive as TM1 data (E: drive). I suppose I can test it in my local machine but then if works in local machine but not on TM1 server then what's does it mean? Kenneth sAttachment = 'E:\System\ExtractFiles\Test.csv'; Regarding the file path, "E:\Syst...
by kenship
Sun Sep 04, 2022 7:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Powershell Snd-MailMessage Fail to Attach File
Replies: 16
Views: 779

Re: Powershell Snd-MailMessage Fail to Attach File

Just wondering but I suppose I can still call the script from TI right? If so, then yes please share I definitely appreciate it. Kenneth To answer all: https://edu.cubewise.com/2019/11/13/tips-how-to-email-a-report-using-tm1/ - Tested 2 spaces and 1 space have no difference - "Attachments"...
by kenship
Sat Sep 03, 2022 1:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Powershell Snd-MailMessage Fail to Attach File
Replies: 16
Views: 779

Re: Powershell Snd-MailMessage Fail to Attach File

To answer all:

https://edu.cubewise.com/2019/11/13/tip ... using-tm1/

- Tested 2 spaces and 1 space have no difference
- "Attachments" not "Attachment"
by kenship
Fri Sep 02, 2022 3:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Powershell Snd-MailMessage Fail to Attach File
Replies: 16
Views: 779

Powershell Snd-MailMessage Fail to Attach File

Hi all, I have a functioning TI process to send email. I'm trying to modify it to attach file but failed. sFrom = 'TM1_Alert@123XYZ.com'; sTo1 = pRecipient1; sSubject =pSubject; sBody = pBody; sSMTPServer = 'smtp.123XYZ.com'; sAttachment = 'E:\System\ExtractFiles\Test.csv'; # build powershell comman...
by kenship
Sat Aug 06, 2022 1:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Spread Failed For Some Users With Access
Replies: 8
Views: 812

Re: Data Spread Failed For Some Users With Access

Thks for considering all possibilities. ReadOnlyUser - never Lock - none (user of the same group has been doing input almost daily for years) Users of the same group have been able to input while a few individuals couldn't (until their client account was deleted and they log in) Temp cube - none fou...
by kenship
Thu Aug 04, 2022 10:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Spread Failed For Some Users With Access
Replies: 8
Views: 812

Re: Data Spread Failed For Some Users With Access

Not in TM1Web nor Excel workbook. Input only performed directly in cube.

Thanks!
burnstripe wrote: Thu Aug 04, 2022 9:24 pm Is it when updating a cell within the excel sheet or when updating a value directly in the cube viewer.

Does the same behaviour occur if the users accessed the workbook through tm1web or just in excel
by kenship
Thu Aug 04, 2022 10:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Spread Failed For Some Users With Access
Replies: 8
Views: 812

Re: Data Spread Failed For Some Users With Access

The same users have input (the error message says data spread but they weren't doing any data spread, only input) issues as well in other cubes and intersection that they were able to perform since inception. Other user in the same group was able to do so in the same cube and intersection. Haven't t...