Search found 13 matches
- Thu Apr 18, 2019 7:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 and SAP HANA Integration
- Replies: 5
- Views: 7823
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.
- 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: 1574
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 ...
- Mon Jan 22, 2018 3:18 pm
- Forum: OLAP Jobs
- Topic: TM1 Developer Job in Clearwater Fl
- Replies: 0
- Views: 45914
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...
- 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: 3030
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 pro...
- 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: 3030
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...
- Mon Jul 25, 2016 4:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Alphabet help
- Replies: 8
- Views: 4993
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...
- Mon Jul 25, 2016 3:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Alphabet help
- Replies: 8
- Views: 4993
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 ...
- Fri Jul 22, 2016 1:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Alphabet help
- Replies: 8
- Views: 4993
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...
- Wed Apr 06, 2016 6:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic Subset not so dynamic
- Replies: 3
- Views: 2777
Re: Dynamic Subset not so dynamic
Thanks for the advice guys. Really appreciate it.
- Tue Apr 05, 2016 1:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic Subset not so dynamic
- Replies: 3
- Views: 2777
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...
- 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: 3762
Re: Limiting dimension titles on an export
Perfect!
That's what I needed to know.
Thanks
That's what I needed to know.
Thanks
- 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: 3762
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 ...
- 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: 3762
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 sel...