TM1 Forum

Hi everyone....from documentation I've read, I almost feel like for sure there is a way to setup a persistent connection on client computers What I want is.... -A user logs in to their workstation via Windows ActiveDirectory logins -If I use perspectives and connect, it doesn't ask me for a cognos u...

I have Cognos Express...and can confirm that CAFE is NOT in it. We are using perspectives

There is a tutorial on how to use the Java TI feature here: https://www.ibm.com/developerworks/community/groups/community/TM1SDK Thanks for that. Not quite what I was expecting either, but it'll require some exploration time. So stupid question....does this mean that a TI Process can call and run a...

Thanks for input but that's not what I am asking. I want to actually multiply the first cube by the second cube and get a result to aggregate. Well, actually, that is what you are asking. In order for the calculations to aggregate, you have to have the proper dimensionality in a cube to do the aggr...

This is pretty much Multi-dimensional Modelling 101 here. You decide along what axes you want to summarize by and make them dimensions where each of them have a top-level parent that sums all the children. From the looks of things, the third cube would have Company, Week, Province (or maybe this co...

I am not sure whether this can be done nor what is the best approach to do this, so maybe someone can shed some light here. -I have a cube that contains the following: Start date, Province, company, widget# This cube is wehere company information resides -I have a second cube that contains the follo...

Hi there, I would LOVE to include this code in my macros. Could you post it for me to use? Instead of me trying to figure all this out? PPPLLLLLLLEASSSEEE I'm not sure which part of Tomok's reply was unclear. The part where he implied that such a design is a bad idea? The bit where he implied that ...

If I needed to make a business case on why I should use TM1 over tools such as Microsoft SASS, could I get a few pros and cons in a few sentences? Only things I can think of is. Pros -writeback capability -forecasting ? -easier to learn than SSAS ? Cons -Not the best integration with Excel (active f...

Hello, I was thinking about this from your earlier post:- Therefore a snapshot takes ALOT less time to generate on demand I assume you mean generating a snapshot to Excel from a cube view. I may be completely wrong here but I would have thought that the work involved for TM1 in the initial generati...

Hello, I think you may be jumping ahead a little considering API programming and data exports at this stage. The requirement you have described (as I understand it) seems to be fundamental TM1/Excel functionality as suggested by lotsaram. My suggestion would be Build a report in Excel that shows th...

Why "using a TI process"? The best way to get data from a view into Excel is to have an array of DBRW formulas in Excel and simply recalculate. Easy, quick, simple, no fuss. Why complicate things? If this requires automation and output in an excel file with no links to a tm1 server then I...

Why "using a TI process"? The best way to get data from a view into Excel is to have an array of DBRW formulas in Excel and simply recalculate. Easy, quick, simple, no fuss. Why complicate things? If this requires automation and output in an excel file with no links to a tm1 server then I...

Yes, I exclude the zeros. I should rephrase that sentence. I can figure that out....but I am more interested in copying EXACTLY what is in the view I created and exporting EXACTLY what is in that view to a cma file or excel file. Hence the question about snapshotting to Excel

Thanks!

Is there anyway to have a view of aggregated data snapshotted to excel using a TI process? I have a cube that is using daily values....its huge and if I use the ascii output for that it takes forever. So I made a view to aggregate into weeks. I can snapshot into excel no problem and doesn't take too...

Hi there

I am noobie in TM1 and a little familiar with report bursting, what does this actually do?

Does it send a snapshot of a view to an email"?

Hi there, I would LOVE to include this code in my macros.

Could you post it for me to use? Instead of me trying to figure all this out?

PPPLLLLLLLEASSSEEE

Hi There elugan or Anyone else.

I have this exact same problem, and I was wondering how you did this.

What database are you using? How did you push the data there?

I am a newbie for both TM1 and Tableau, so please bare with me.....

Thanks!