TM1 Forum

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.

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 ...

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...

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...

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...

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...

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 ...

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...

Thanks for the advice guys. Really appreciate it.

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...

Perfect!

That's what I needed to know.

Thanks

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 ...

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...