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?
TM1 Drill-through to ReportStudio
- tianoklein
- Posts: 41
- Joined: Fri Jun 13, 2014 1:23 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
-
- MVP
- Posts: 3667
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: TM1 Drill-through to ReportStudio
You can't. You can drill through either to a cube view or to the result of a SQL query.tianoklein wrote:How can I make a drill-through to a Cognos Report Studio?
What you could do is have a string measure holding the hyperlink path of the report and make it visible to the user.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
- tianoklein
- Posts: 41
- Joined: Fri Jun 13, 2014 1:23 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: TM1 Drill-through to ReportStudio
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!
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!
-
- MVP
- Posts: 1817
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TM1 Drill-through to ReportStudio
If it's used through a perspectives linked sheet or TM1 Web form then you can just use the excel HyperLink() formula.
Declan Rodger
- tianoklein
- Posts: 41
- Joined: Fri Jun 13, 2014 1:23 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: TM1 Drill-through to ReportStudio
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!
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!
-
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
Re: TM1 Drill-through to ReportStudio
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.
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
- Posts: 41
- Joined: Fri Jun 13, 2014 1:23 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: TM1 Drill-through to ReportStudio
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?
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?
-
- MVP
- Posts: 1817
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TM1 Drill-through to ReportStudio
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.)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?
Out of interest why are you against using websheets in your contributor model?
Declan Rodger