excel

Post Reply
angel1234
Posts: 44
Joined: Mon May 17, 2010 8:14 am
OLAP Product: tm1 cognos
Version: 9.5
Excel Version: 2007

excel

Post 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
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: excel

Post 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.
kpk
MVP
Posts: 214
Joined: Tue Nov 11, 2008 11:57 pm
OLAP Product: TM1, CX
Version: TM1 7x 8x 9x 10x CX 9.5 10.1
Excel Version: XP 2003 2007 2010
Location: Hungary

Re: excel

Post 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
Best Regards,
Peter
Post Reply