Search found 101 matches

by tm123
Wed May 16, 2018 4:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security Access Flag not being Deployed
Replies: 6
Views: 176

Re: Security Access Flag not being Deployed

The only line that changes is the encrypted line i posted in my prior post, but that line changes even if you save without making any change to the process ( i mean you dont change any thing in the TI, and you dont change the security access setting.) But my issue is why do you have to save the TI w...
by tm123
Wed May 16, 2018 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security Access Flag not being Deployed
Replies: 6
Views: 176

Re: Security Access Flag not being Deployed

Not sure if this has changed at some point but I've always had to do this since this bit of logic was introduced. Not sure where the security access state of a TI is stored, I would have though there ought to a }Process_Properties cube somewhere but I've never spotted where. AFAIK the security stat...
by tm123
Wed May 16, 2018 12:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: show recently added elements in subset.
Replies: 5
Views: 119

Re: show recently added elements in subset.

Why don't you add an attribute to the dimension and use it for Filtering or SOrting? You cannot rely on the Element Index since it changes How attribute will identify the new element? it is not necessary in source data that new elements will come at last if i assign attribute as incremental numbers...
by tm123
Wed May 16, 2018 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: show recently added elements in subset.
Replies: 5
Views: 119

Re: show recently added elements in subset.

Why don't you add an attribute to the dimension and use it for Filtering or SOrting? You cannot rely on the Element Index since it changes
by tm123
Wed May 16, 2018 12:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security Access Flag not being Deployed
Replies: 6
Views: 176

Security Access Flag not being Deployed

Hi guys, I am facing a strange issue. I have a few TI Processes that update some dimensions with ElementSecurity (}ElementSecurity bubes being populated by Rules). The TIs are also refreshing security, and since the user who runs the TIs is not an admin, I enabled the Flag "Security Access" on each ...
by tm123
Wed May 02, 2018 1:32 pm
Forum: Enhancements
Topic: Determine whether a TI process exists
Replies: 9
Views: 3576

Re: Determine whether a TI process exists

Follow up: ProcessExists has been added recently to the TI functions. Thank you IBM. It would be nice if they also added a TI Function to delete a TI Process (such as ProcessDestroy or ProcessDelete). I have some TI Processes that their names start with } (like control objects) and they cannot be d...
by tm123
Mon Apr 09, 2018 4:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help on Rule in }ElementSecurity_Dimension
Replies: 2
Views: 166

Re: Help on Rule in }ElementSecurity_Dimension

You can try something like below. I try to hardcode element names in Rules so you might have to use some mapping cube or dimension attributes to map Regions to User Groups [ 'Group_Name' ] = S: IF ( ELISANC('DimName', !DimName, 'Benelux') = 1 % ELISANC('DimName', 'Benelux', !DimName ) = 1 % !DimName...
by tm123
Tue Apr 03, 2018 2:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Get all SQL from TI processes
Replies: 4
Views: 433

Re: Get all SQL from TI processes

That's why externalizing the SQL Code is a good practice. For all our processes, we have a Control Cube where we keep the Data Source Type and also the Data SOurce Query (which will be SQL Query for processes with ODBC Data Type, MDX Statement or a saved subset name for Processes using a Dimension a...
by tm123
Wed Mar 28, 2018 2:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Possible to provide line space in comments?
Replies: 5
Views: 477

Re: Possible to provide line space in comments?

I'm trying to send to email notification using powershell. For the email's body I wish to add line space to look something like below Hi All, Load has completed. My current code is sSubject = ' load completed' ; sBody = ' load completed'; # build powershell command sPsCmd = '"& { Send-MailMessage -...
by tm123
Tue Mar 27, 2018 1:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting TM1 data in multiple sheet of workbook
Replies: 2
Views: 394

Re: Exporting TM1 data in multiple sheet of workbook

I think you can create an ODBC connection that points to an Excel SPreadsheet, and then you have to use ODBCOutput to write data do specific Excel Tabs. I have not tried this but I have tried using Excel as ODBC data source for other reasons and it works
by tm123
Thu Mar 22, 2018 3:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy Changes affecting BI reports
Replies: 2
Views: 281

Re: Hierarchy Changes affecting BI reports

You need to execute RefreshMdxHierarchy after the Dimension Hierarchy changes.
by tm123
Wed Mar 21, 2018 12:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Server Name reference in workbook
Replies: 11
Views: 2300

Re: Dynamic Server Name reference in workbook

This work only in PAX, But you can use it in Perspectives (with error displayed) and upload workbook to websheet: this will work without PAX (but will be difficult to debug). Again one of those stupid IBM "new features". This has been always a limitation in TM1, but since they took the effort to in...
by tm123
Tue Mar 20, 2018 9:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Server Name reference in workbook
Replies: 11
Views: 2300

Re: Dynamic Server Name reference in workbook

Hello, In PA 2.0 there is the "TM1PRIMARYDB" function: Returns the primary TM1 server name that the user is authenticated through, even if the user is implicitly logged in to multiple TM1 servers.: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_nfg.2.0.0.doc/c...
by tm123
Wed Feb 28, 2018 1:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting changed data only - flag?
Replies: 8
Views: 593

Re: Exporting changed data only - flag?

Hi! Here is an issue we have been facing pretty much since we started our project: We are currently loading all data from our TM1 10.2.2 to our DB every night (couple dimensions with 50+ elements), because we cannot narrow our subset of what to export down. Users might change any data at any time, ...
by tm123
Tue Feb 27, 2018 9:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button Caption Text Disappears When Scrolling Mouse
Replies: 4
Views: 379

Re: Action Button Caption Text Disappears When Scrolling Mouse

My apology for not mentioning it. It's in Excel. Is this happening in Excel or TM1Web? I have seen some weird behavior like this with websheets with Frozen Panes, so the Action Buttons on the RIght Pane were not working properly so I had to move them on the Left Pane. But in TM1Web, they were worki...
by tm123
Mon Feb 26, 2018 4:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web 10.2.2 compare to 2.0.3 Version
Replies: 1
Views: 275

Re: TM1 Web 10.2.2 compare to 2.0.3 Version

Hard to understand your screenshot since it's not English :)

What do you expect to happen? By Excel Tab you mean you TM1Web Websheet has multiple tabs?
Also by Grayed Out you mean the color or "Locked" so the user cannot update them?
by tm123
Thu Feb 22, 2018 4:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Chore Schedule Information
Replies: 10
Views: 827

Re: TM1 Chore Schedule Information

We can check chore active status and schedule in TM1 web prior to 10.2 version. Currently my TM1 version is 10.2.2, I don't see any direct option where I can check these details with out deactivating the chore. Let me know if there any way to figure it out. *.cho files are text files and it's easy ...
by tm123
Thu Feb 22, 2018 4:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic listing of elements using MDX
Replies: 9
Views: 629

Re: Dynamic listing of elements using MDX

Any other changes to be done ? Excel doesn't concatenate strings using the pipe symbol (|). Change your MDX code to not concatenate those strings together. For that matter, I don't understand why you can't make the MDX just one long string anyway??? Sorry thats my bad. I had written a code in TI wi...