TM1 Drill-through to ReportStudio

[tianoklein]

How can I make a drill-through in a tm1 cellcube to a hyperlink like Cognos Report Studio.
I can make drill-up and drill-down, drill to another cube or odbc, but how can I make a drill-through to a Cognos Report Studio?

[lotsaram]

How can I make a drill-through to a Cognos Report Studio?

You can't. You can drill through either to a cube view or to the result of a SQL query.
What you could do is have a string measure holding the hyperlink path of the report and make it visible to the user.

[tianoklein]

Hello lotsaram,
This is a good for me..
How can I put a hiperlink as a string item?
Do you use a function, or somthing like that?
Many Thanks!

[declanr]

If it's used through a perspectives linked sheet or TM1 Web form then you can just use the excel HyperLink() formula.

[tianoklein]

Declanr,
Thanks for your quickly response.

Unfortunatly, I'm using TM1 Contributor.
I also need the link is dynamic, passing parameter by the row/column selected (like a Drill-through in Transformer cube).

Many thanks!

[PlanningDev]

This is easily done using basic excel functionality to concatenate a string that represents the BI URL you want. Read up on the BI URL API and then simply create the url and use it in the HYPERLINK function in excel.

This generally only works as a websheet due to the limitation of the number of characters hyperlink will accept in excel. Even though it shows an error in excel it will work over the web.

[tianoklein]

Thanks PlanningDev,
But I'm using TM1 Contributor to make my tm1 cube (not Perspectives).
I can re-build my application to a perspectives, but I think isn't good idea.

Do you know if exist some function like hyperlink()to cubeview?

[declanr]

Thanks PlanningDev,
But I'm using TM1 Contributor to make my tm1 cube (not Perspectives).
I can re-build my application to a perspectives, but I think isn't good idea.

Do you know if exist some function like hyperlink()to cubeview?

You can use the URL api to open a cubeviewer in tm1 but not from a cubeviewer to something else. The closest you'd get is just having a url populated string measure and telling users to paste it into their browsers (not very user friendly.)

Out of interest why are you against using websheets in your contributor model?