Search found 219 matches

by RJ!
Mon May 29, 2017 10:42 am
Forum: Cognos TM1
Topic: DBRW not returning a value in TM1 Web
Replies: 3
Views: 486

Re: DBRW not returning a value in TM1 Web

XLSM -> Because just habit, just thought I'd mention in case it made a difference.

The DBRW is using cell references to populate the Service & User ID + Text for the "Status" field in my }ClientProperties cube
by RJ!
Mon May 29, 2017 10:30 am
Forum: Cognos TM1
Topic: Certification
Replies: 1
Views: 385

Re: Certification

Certified Financial Planner -> Advise people on their Finances such as Superannuation, Investments, Tax Strategy etc Accounting Certification -> Understand Accounting which can include budgeting & forecasting I think something like CIMA / CGMA is what you mean for Professional Certification for Bud...
by RJ!
Fri May 19, 2017 3:05 am
Forum: Cognos TM1
Topic: DBRW not returning a value in TM1 Web
Replies: 3
Views: 486

Re: DBRW not returning a value in TM1 Web

OK, works for normal cubes, just not System Cubes. No way around this?
by RJ!
Fri May 19, 2017 2:44 am
Forum: Cognos TM1
Topic: DBRW not returning a value in TM1 Web
Replies: 3
Views: 486

DBRW not returning a value in TM1 Web

Hi All, We have build XLSM form & published on to TM1 Web that uses a DBRW formula to retrieve a value from the }ClientProperties cube. The DBRW works fine when we calculate in Perspectives, but once it's loaded into TM1 Web, the DBRW does not. I tried using DBR instead with the same result. This is...
by RJ!
Thu May 04, 2017 2:02 am
Forum: Cognos TM1
Topic: Alternative of Cognos TM1
Replies: 2
Views: 611

Re: Alternative of Cognos TM1

Excel!

You can create your own Excel Hell to manage a budget & pass the data back & worth to your NO-SQL back end DB's.
by RJ!
Tue Mar 14, 2017 10:04 pm
Forum: Cognos TM1
Topic: Migrating Perspectives Reports to CAFÉ - experience?
Replies: 4
Views: 1417

Re: Migrating Perspectives Reports to CAFÉ - experience?

FYI - If you are using DBRA in CAFE, it seems it only likes the native (?) element, if you use any alias it returns blank.
(This is using 10.2.2 FP6)
by RJ!
Fri Jan 13, 2017 6:42 am
Forum: Cognos TM1
Topic: SecAdmin + TM1Web Applications
Replies: 2
Views: 446

Re: SecAdmin + TM1Web Applications

Thanks Lotsaram. Even when the user has access to other "User" type groups, we were still getting this issue. I've assumed that this is a limitation put on SecurityAdmin users so have created a new Group SecurityMaintenance & only gave that group access to the SecAdmin Application in TM1Web + the Pr...
by RJ!
Fri Jan 13, 2017 2:30 am
Forum: Cognos TM1
Topic: SecAdmin + TM1Web Applications
Replies: 2
Views: 446

SecAdmin + TM1Web Applications

Hi All, I have been trying to create something in TM1Web to allow our SecurityAdmin team to be able to update Client data via an Excel Template & stored as an Application. During my testing as DataAdmin, all works fine, if test as any Client that has any group access other than SecurityAdmin, its st...
by RJ!
Fri Dec 23, 2016 1:19 am
Forum: Cognos TM1
Topic: Planning Analytics Local 2.0 - Where is TM1Web?
Replies: 14
Views: 2443

Re: Planning Analytics Local 2.0 - Where is TM1Web?

When you say you "don't have access to" the IBM site... you DO have an account (probably Passport Advantage , but with the way IBM runs its customer accounts who the h3ll knows if it's the same for everyone), yes? Because without that, you can't log in and without logging in, you can't download the...
by RJ!
Wed Dec 21, 2016 12:41 am
Forum: Cognos TM1
Topic: Planning Analytics Local 2.0 - Where is TM1Web?
Replies: 14
Views: 2443

Re: Planning Analytics Local 2.0 - Where is TM1Web?

Embarrassing question but what are you searching to get the new Planning Analytics Local?

I don't have access to the IBM site & our IT support can only find the cloud version.
by RJ!
Mon Oct 17, 2016 5:52 am
Forum: Cognos TM1
Topic: new cube view slicing feature in CAFE 10.3
Replies: 2
Views: 333

Re: new cube view slicing feature in CAFE 10.3

This the Cloud based version?

Might have to get the IT department to giddy up if there is a new CAFE available for On Premise.
by RJ!
Mon Oct 17, 2016 5:51 am
Forum: Cognos TM1
Topic: TM1 10.3 - IBM Planning Analytics
Replies: 40
Views: 11589

Re: TM1 10.3 - IBM Planning Analytics

Paul Segal wrote:I heard Q3 is the current target for on premise release. Of course, that might slip ;)
Next year?
by RJ!
Mon Oct 17, 2016 5:34 am
Forum: Cognos TM1
Topic: RAM Issues with 10.2.2 Upgrade
Replies: 4
Views: 492

Re: RAM Issues with 10.2.2 Upgrade

My understanding is that on your first start up, TM1 will do all of the calculations to feed your cubes (and WRITE to your Feeder files), this can lead to a lot of "Garbage" in your RAM. On the 2nd restart, since you have persistent Feeders, TM1 will look for your .FEEDER files and load the cubes ba...
by RJ!
Fri Aug 26, 2016 3:36 am
Forum: Cognos TM1
Topic: TM1 REST API ( Any early adopters )
Replies: 52
Views: 17022

Re: TM1 REST API ( Any early adopters )

I've seen a generic "Login/Test" page that was created by an IBM Dev that's supposedly out in the wild now.
It allows you to login, test your GET & POST commands and see the resulting data from TM1.

I'm sure if you ask your IBM rep or TM1 consultant really nicely, they'll give it to you.
by RJ!
Fri Aug 26, 2016 3:22 am
Forum: Cognos TM1
Topic: Security Admin and Data Admin -> need Administrator license?
Replies: 7
Views: 997

Re: Security Admin and Data Admin -> need Administrator license?

Have you looked to see if you can make the changes to the user profile with the BedRock processes?
If so, then the Senior Controller just needs access to those to perform the function you need.
by RJ!
Wed Jul 13, 2016 11:27 pm
Forum: Cognos TM1
Topic: TM1TOP shows repeated logins
Replies: 13
Views: 656

Re: TM1TOP shows repeated logins

Are you using CAFE?

We had Zombie threads from CAFE Users until we went to FP4 of the latest build.
by RJ!
Mon Jul 11, 2016 2:02 am
Forum: Cognos TM1
Topic: TM1 Perspective SpreadSheet Browser (ISB) Objects Issue. Please advice.
Replies: 2
Views: 386

Re: TM1 Perspective SpreadSheet Browser (ISB) Objects Issue. Please advice.

I get the same issue, mostly get that when I change the "View" it had initially to something else and then save the file. My temporary fix was to use a Default "View" that my users have to change each time they open the template. Not the best solution but we only use ISB to pull a View that can be u...
by RJ!
Wed Jun 01, 2016 12:07 am
Forum: Cognos TM1
Topic: MDX 3+ Months rolling solution required
Replies: 15
Views: 1339

Re: MDX 3+ Months rolling solution required

I'd take issue with the statement that using a flat time dimension for reference is inelegant. Only meant to say not elegant as in sticking to a solution with 2Dim per the OP set up. Another solution might be to add 3 (or 6) attributes to the Month Dim to store Mth-1, Mth-2, Mth-3 & then some logic...
by RJ!
Tue May 31, 2016 6:50 am
Forum: Cognos TM1
Topic: MDX 3+ Months rolling solution required
Replies: 15
Views: 1339

Re: MDX 3+ Months rolling solution required

Just throwing it out there...

Why not create a Dim that has the consecutive periods, run your MDX against that to get your "last 3mths" and then chop the "Period" back to Month & Year?

Not a particularly elegant solution but would solve for what you want?