Search found 13 matches

by Bucjeff
Thu Apr 18, 2019 7:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 and SAP HANA Integration
Replies: 5
Views: 1082

Re: TM1 and SAP HANA Integration

We are connecting via ODBC and using sql to extract data from HANA views. Maybe more detail in your question will get more detailed help.
by Bucjeff
Tue Jan 22, 2019 8:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Passing Parameters to a HANA View
Replies: 1
Views: 205

Passing Parameters to a HANA View

Hi all, Connecting to a HANA 1.0 revision 122 view via ODBC. Standard selections are working fine. When I need to pass parameters into the view/query is where I am lost on the proper syntax. I have pFiscalPrd and pSource setup as string parameters. Here is the sql. The 2 Enter Value is where I want ...
by Bucjeff
Mon Jan 22, 2018 3:18 pm
Forum: OLAP Jobs
Topic: TM1 Developer Job in Clearwater Fl
Replies: 0
Views: 1241

TM1 Developer Job in Clearwater Fl

I have a FT developer position based in Clearwater Florida for a Fortune 100 company. Working on several different models that either are global or soon will be. The need is fairly immediate. User population is Americas, Europe, and ASIA PAC. Prefer at least 3+ years experience with a degree in IT o...
by Bucjeff
Mon Oct 30, 2017 8:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing data on server re-boot
Replies: 4
Views: 722

Re: Changing data on server re-boot

Maybe the "reboot" is a red herring. What about any startup processes or chores that may get run right after a server restart. Could there be one that is wiping out the data you're looking for. That's where I would be looking. There is also a slight chance that your cube is not saving properly. Wha...
by Bucjeff
Mon Oct 30, 2017 3:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing data on server re-boot
Replies: 4
Views: 722

Changing data on server re-boot

we are on fix pack 5 10.2.20500.75 We have data on an employee record that is being cleared only when the server is re-booted. I changed the logging to DEBUG to get everything I could possibly look at. Went through them all and found nothing that is obvious this morning. This field is not a calculat...
by Bucjeff
Mon Jul 25, 2016 4:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Alphabet help
Replies: 8
Views: 1418

Re: Alphabet help

Polog tab ###DEFINE VARIABLES### strCubeSource = 'bpmComp_EmpInfo' ; strCubeTarget = 'bpmEmpID_Info' ; strView = 'zzPopulateEmpIDcube' ; strSub = strView ; strEmpIDDim = 'bpmEmpID'; strEmpIDRoot = 'Total EmpID'; strEmpMsrDim = 'bpmEmpID_Msr'; ##################################### # CREATE Target VIE...
by Bucjeff
Mon Jul 25, 2016 3:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Alphabet help
Replies: 8
Views: 1418

Re: Alphabet help

Steve As far as whats actually going wrong. In the lookup cube I have last names under an alphabetical consolidation that do not begin with the consolidation level. Last name of Bearce under the C and so forth. A name is only under one consolidation level so in this example Bearce is not under the ...
by Bucjeff
Fri Jul 22, 2016 1:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Alphabet help
Replies: 8
Views: 1418

Alphabet help

We have a lot of employee movement between departments and the budget team needed a quick employee lookup to see where an employee currently is in our org structure. I built a process so that they can type a first letter of a last name to find someone's current information. Problem is There are a sm...
by Bucjeff
Wed Apr 06, 2016 6:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subset not so dynamic
Replies: 3
Views: 911

Re: Dynamic Subset not so dynamic

Thanks for the advice guys. Really appreciate it.
by Bucjeff
Tue Apr 05, 2016 1:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subset not so dynamic
Replies: 3
Views: 911

Dynamic Subset not so dynamic

Hi all, I have a finance report that shows GL accounts and amounts where the user can select any level of the organization hierarchy. There is a drop down to select the level to show. This is a dynamic subset built in the subset editor with the following MDX { EXCEPT( { EXCEPT( { EXCEPT( { DRILLDOWN...
by Bucjeff
Wed Aug 12, 2015 7:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Limiting dimension titles on an export
Replies: 4
Views: 1425

Re: Limiting dimension titles on an export

Perfect!

That's what I needed to know.

Thanks
by Bucjeff
Wed Aug 12, 2015 4:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Limiting dimension titles on an export
Replies: 4
Views: 1425

Re: Limiting dimension titles on an export

I fully admit to being a new user and a bit daft at that. My issue is the export process wants to create a tab for every member of the total company hierarchy - even when a much smaller set is selected in the report on the web. The drop down with the subnm has the entire hierarchy available. when a ...
by Bucjeff
Fri Jul 31, 2015 2:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Limiting dimension titles on an export
Replies: 4
Views: 1425

Limiting dimension titles on an export

Hi all, VERY new TM1 user. We haven't gone live yet and I am developing reporting. I have an active form report that does great on the web. I really like the functionality of the export to PDF or Excel, especially the ability to create what I would call a " book" from the one report by selecting a d...