Page 1 of 1

excel

Posted: Sat Jun 12, 2010 9:25 am
by angel1234
hi,

Is there any function in turbo integrator which gives the slice of a particular cube on the excel perspective??? i know a dedicated tab is directly available in excel(explorer-->cube viewer-->slice).but i need to explore is there any function in turbo integrator which does the same function??

thanks and regards
angel

Re: excel

Posted: Sat Jun 12, 2010 11:59 am
by lotsaram
I find your question a little confusing and wonder if in fact you are confused?

TurboIntegrator is foremost an ETL and administrative tool. Although you may access the TurboIntegrator client via the Excel Perspectives add-in all actions of TurboIntegrator when processes are running occur server side as an integrated component of the TM1 server. There is therefore no actual link between TurboIntegrator and Excel in any real way.

There is no command in TurboIntegrator to create a slice in Excel (that is what Perspectives is for!) The closest you would get would be to ASCIIOutput a CSV file.

Re: excel

Posted: Sun Jun 13, 2010 6:47 am
by kpk
When you use the drill function from an excel slice then TI can open a slice in a new sheet on the client side.
Maybe this can give a chance for a workaround for you.
E.g: You can build a "navigation" cube and define drill processes for your users.
Sample to check: 'Plan_BudgetPlan' cube > 'Budget Input Detailed' view.

I also recommend you to check the Action button functionalities for navigation between reports.

HTH

Peter