Search found 323 matches

by EvgenyT
Wed May 27, 2020 6:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW error: VIEW_CONVERSION_FAILED
Replies: 1
Views: 54

PAW error: VIEW_CONVERSION_FAILED

Hi Guys,

Never seen this before.. non-admin users are getting this error. Under my admin account works ok.
One would think its security related..? With a typical ambiguous error message!
by EvgenyT
Mon May 25, 2020 4:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Naming Conventions Elements
Replies: 2
Views: 104

Re: Naming Conventions Elements

I try to avoid in case it may conflict with delimiters
by EvgenyT
Fri May 22, 2020 12:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User driven security
Replies: 10
Views: 625

Re: User driven security

Thanks for a very elaborate response Paul. Re: SecurityRefresh, as far as I know only rules require it (but not rule driven cell security). Updating with TI propagates internal security structures without the need of SecurityRefresh. I even recall someone mentioning ElementSecurity* functions being ...
by EvgenyT
Wed May 20, 2020 2:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User driven security
Replies: 10
Views: 625

Re: User driven security

Thanks Yuriy, great feedback! I really wanted to be clever :roll: :roll: :roll: :roll:
I try to avoid being clever around security
- Can we ask IBM to add this to executive summary of TM1 security ? :lol: :lol: :lol: :lol:
by EvgenyT
Tue May 19, 2020 10:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User driven security
Replies: 10
Views: 625

Re: User driven security

In our model, cost center security is user-driven rather than a group. The business is adamant that we can't logically group cost centers to use vanilla group security. There are about 500 cost-centers and as you can imagine having 500 groups would be a nightmare! Did you mean 500 cost centers or 5...
by EvgenyT
Tue May 19, 2020 11:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User driven security
Replies: 10
Views: 625

User driven security

Hi All, Working with unusual requirements here (well, not a common one at least). In our model, cost center security is user-driven rather than a group. The business is adamant that we can't logically group cost centers to use vanilla group security. There are about 500 cost-centers and as you can i...
by EvgenyT
Tue Mar 03, 2020 4:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pulse Query
Replies: 5
Views: 861

Re: Pulse Query

Using IE or Chrome ?
by EvgenyT
Thu Feb 20, 2020 9:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ruled cell not released for write
Replies: 10
Views: 628

Re: Ruled cell not released for write

Try updating attribute with RunProcess, so it commits entirely outside of the processing chain.
CubeSaveData must be added after attribute update.
- No, it only matters if you want to serialize changes to the disk. It does not come into equation when you are committing data.
by EvgenyT
Sun Feb 09, 2020 1:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and Process Ends msg
Replies: 20
Views: 14006

Re: RunProcess and Process Ends msg

Did you bother to check the documentation on the RunProcess function ? https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ref.2.0.0.doc/r_tm1_ref_tifun_runprocess.html There is a section on “Return values”. The return value is JobID which I understand is only poss...
by EvgenyT
Fri Feb 07, 2020 1:02 am
Forum: Useful code, tips and tricks
Topic: Going to the IBM Cloud
Replies: 4
Views: 716

Re: Going to the IBM Cloud

Great summary, thanks.

Just to add, you also have to use non-interactive account if you want to leverage CCS or do REST API calls to your server from a 3rd party software (its in the welcome kit)
by EvgenyT
Wed Feb 05, 2020 8:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Server Issues
Replies: 3
Views: 594

Re: Tm1 Server Issues

Sorry, but this is very ambiguous request for assistance. 1. What do Windows (or Linux) server logs, PA and it's clients server logs say? 2. What are the server specs? RAM? Disk Size? 3. Once the Tm1 server has been restarted, it runs fine for a while in which we can submit, approve, and reject. - I...
by EvgenyT
Mon Feb 03, 2020 10:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 29
Views: 9591

Re: RunProcess explanation

The biggest problem with this new command is there is no way to know when all of them are done so that you can do the next sequential action. For example, after 12 months are loaded, how do you then kick of an allocation script, or a email saying everything is fine. You have to end up jumping throu...
by EvgenyT
Mon Feb 03, 2020 10:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 29
Views: 9591

Re: RunProcess explanation

You can use RushTi to mitigate the risk of blowing up your cores
by EvgenyT
Mon Feb 03, 2020 5:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String size limit of a parameter in a TI
Replies: 11
Views: 627

Re: String size limit of a parameter in a TI

No, issue is with your MDX statement at position 99, try replacing ' " ' around *User* with sQuote = CHAR (34)

sMDX = '{TM1FILTERBYPATTERN( {TM1FILTERBYLEVEL( {TM1SORT( {TM1SUBSETALL( [Process Control Element] )}, ASC)}, 0)}, ' | sQuote |'*User*'| sQuote| ')}';
by EvgenyT
Thu Jan 30, 2020 5:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI MDX query of 2 different cubes
Replies: 14
Views: 786

Re: TI MDX query of 2 different cubes

Just going back to basics... does all this data need to be in 3 separate models?


Thanks
by EvgenyT
Thu Jan 30, 2020 3:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: License implication for providing data via REST API
Replies: 4
Views: 325

Re: License implication for providing data via REST API

Interesting question.. Given you would need to authenticate with an admin account, would it not be covered by your current admin license? Same as query data via any PA client? https://www-03.ibm.com/software/sla/sladb.nsf/pdf/6398-08/$file/i126-6398-08_03-2019_en_US.pdf IBM Planning Analytics Modele...
by EvgenyT
Fri Jan 24, 2020 2:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Possibility of Amazon AWS S3 to TM1 On-Prem
Replies: 4
Views: 395

Re: Possibility of Amazon AWS S3 to TM1 On-Prem

thank you so much for a quick response Evgeny. you are correct. we have the Amzon Redshift where all the flat-files are located. So, our tm1 10.2.2 On-Prem needs to connect to flat-files to read the data?. Could you please brief more about on this. maybe solution approach? I am confused, files sitt...