If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to add LINK to CrossTab intersecting data

Started by longbaobao, 18 Oct 2013 04:59:21 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

longbaobao

18 Oct 2013 04:59:21 PM Last Edit: 22 Oct 2013 11:15:56 AM by longbaobao
I'm using report studio to create report. I already built a cross tab whose row is [date] and column is [Test Suit Name] and the data is a percentage [rate]. These three queries are all from one table. I have another column in the same table named [url].

I want to add the [url] to the data [rate] so that it can link to an external web site.

I know how to add a url to the data. Do something like add two <html> mark before and after the data. But I always got error when I try to put [url] into the table. Can anyone help me with this? Is it possible to achieve this with non-dimentional data(relational data)?

CognosPaul

#1
19 Oct 2013 01:19:59 PM
Does url exist in your crosstab? Are you referencing it anywhere in your crosstab? Try adding it to the properties list in Date(All) or Test Suite Name.

longbaobao

#2
19 Oct 2013 08:58:11 PM Last Edit: 19 Oct 2013 10:38:59 PM by longbaobao
Quote from: CognosPaul on 19 Oct 2013 01:19:59 PM
Does url exist in your crosstab? Are you referencing it anywhere in your crosstab? Try adding it to the properties list in Date(All) or Test Suite Name.

Thank you so much for your reply. Good news is it works! But not working that properly. Some of the url refers to the wrong destination. The data in the crosstab ([passed rate]) is one to one mapping with [url]. I got wrong result either when I add [url] to the row property or to the column property or both of them. Do you know how can I set [url] to [passed rate] (the intersection of crosstab)? Thank you again.

CognosPaul

#3
20 Oct 2013 01:11:50 AM
Is the url supposed to change based on Date or Test Suite?

The properties allows Cognos to provide context for the nodes. An example would be adding the category code for a month. So the month name might be June, but the only way to get the month number in a drilllthrough or HTML item would be to use the properties.

Another thing you could try - drag the URL next to one of the nodes. This way you are certain to get the correct URL, but you may get some unexpected results.

longbaobao

#4
21 Oct 2013 08:09:54 AM Last Edit: 21 Oct 2013 09:29:39 AM by longbaobao
Quote from: CognosPaul on 20 Oct 2013 01:11:50 AM
Is the url supposed to change based on Date or Test Suite?

The properties allows Cognos to provide context for the nodes. An example would be adding the category code for a month. So the month name might be June, but the only way to get the month number in a drilllthrough or HTML item would be to use the properties.

Another thing you could try - drag the URL next to one of the nodes. This way you are certain to get the correct URL, but you may get some unexpected results.

The url can be determined by the row and column. But either one of them cannot solely determine the url. Do you know if it is possible for me to add [url] to the fact cells([rate]) or the property of it? I can't find any way to achieve this......

esar

#5
22 Oct 2013 09:24:40 AM
Inorder to get proper URL value, it should be a part of the fact cells(as hidden). But I dont thing you would be able to add URL since it is not numeric. Are the distinct URL values from the database, static or will you get new URLs in due time? how many distinct URLS do you have.

longbaobao

#6
22 Oct 2013 09:36:30 AM
Quote from: esaravana on 22 Oct 2013 09:24:40 AM
Inorder to get proper URL value, it should be a part of the fact cells(as hidden). But I dont thing you would be able to add URL since it is not numeric. Are the distinct URL values from the database, static or will you get new URLs in due time? how many distinct URLS do you have.

One number in the crosstab corresponding to a unique url. The [url] and [rate] are two columns in a table and mapping one to one. If I can add the [url] to crosstab intersection as a hidden data item, the problem is solved. But I don't think it is possible to add more than one query in crosstab intersection. If you know, could you please tell me how? Thanks.

CognosPaul

#7
22 Oct 2013 10:37:18 AM
So the URL is a combination of the rows and columns.

Crosstabs still don't support text in the measures section. Is it a finite list that you can rebuild using a case statement? Or can you recreate the URL with something like

'http://whatever/something?'+[Row Node Attribute] + '-'+[Column Node Attribute]

longbaobao

#8
22 Oct 2013 11:11:13 AM
Quote from: CognosPaul on 22 Oct 2013 10:37:18 AM
So the URL is a combination of the rows and columns.

Crosstabs still don't support text in the measures section. Is it a finite list that you can rebuild using a case statement? Or can you recreate the URL with something like

'http://whatever/something?'+[Row Node Attribute] + '-'+[Column Node Attribute]

That is a smart idea.

But unfortunately no. Although only the last part of the [url] is not the same,  it is encrypted. For example, all url start with ABC and the whole url is like "ABC/slug__6wkhdCrdEeOx68ayLi-3Ig" and "ABC/slug__nqp5hCsqEeOx68ayLi-3Ig".  I can't see which column can generate the 5 different characters.
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite