Page 1 of 1
TM1 Drill-through to ReportStudio
Posted: Fri Aug 15, 2014 12:39 pm
by 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?
Re: TM1 Drill-through to ReportStudio
Posted: Fri Aug 15, 2014 2:24 pm
by lotsaram
tianoklein wrote: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.
Re: TM1 Drill-through to ReportStudio
Posted: Fri Aug 15, 2014 3:01 pm
by 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!
Re: TM1 Drill-through to ReportStudio
Posted: Fri Aug 15, 2014 5:35 pm
by declanr
If it's used through a perspectives linked sheet or TM1 Web form then you can just use the excel HyperLink() formula.
Re: TM1 Drill-through to ReportStudio
Posted: Fri Aug 15, 2014 6:06 pm
by 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!
Re: TM1 Drill-through to ReportStudio
Posted: Fri Aug 15, 2014 7:10 pm
by 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.
Re: TM1 Drill-through to ReportStudio
Posted: Mon Aug 18, 2014 1:17 pm
by 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?
Re: TM1 Drill-through to ReportStudio
Posted: Mon Aug 18, 2014 5:51 pm
by declanr
tianoklein wrote: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?