Hi all,
I'm trying to compute correlation between two variables, in cognos dashboard, as follows:
corr( tuple(value;variabile1); tuple(value;variabile2))
but the outcome is the following:
The function corr is not supported by the origin data JD-D2
i have tried to compute this on report too and i have the same error, but it works only with data produced by SQL query, if i put dimensional member in the same report query i have the same error 
How i can compute on dashboard? 

Thanks

------------------------------
valerio pascarella
------------------------------

Hi all,
I'm trying to compute correlation between two variables, in cognos dashboard, as follows:
corr( tuple(value;variabile1); tuple(value;variabile2))
but the outcome is the following:
The function corr is not supported by the origin data JD-D2
i have tried to compute this on report too and i have the same error, but it works only with data produced by SQL query, if i put dimensional member in the same report query i have the same error 
How i can compute on dashboard? 

Thanks

------------------------------
valerio pascarella
------------------------------

Hi all,
I'm trying to compute correlation between two variables, in cognos dashboard, as follows:
corr( tuple(value;variabile1); tuple(value;variabile2))
but the outcome is the following:
The function corr is not supported by the origin data JD-D2
i have tried to compute this on report too and i have the same error, but it works only with data produced by SQL query, if i put dimensional member in the same report query i have the same error 
How i can compute on dashboard? 

Thanks

------------------------------
valerio pascarella
------------------------------

Hi all,
I'm trying to compute correlation between two variables, in cognos dashboard, as follows:
corr( tuple(value;variabile1); tuple(value;variabile2))
but the outcome is the following:
The function corr is not supported by the origin data JD-D2
i have tried to compute this on report too and i have the same error, but it works only with data produced by SQL query, if i put dimensional member in the same report query i have the same error 
How i can compute on dashboard? 

Thanks

------------------------------
valerio pascarella
------------------------------

Hi all,
I'm trying to compute correlation between two variables, in cognos dashboard, as follows:
corr( tuple(value;variabile1); tuple(value;variabile2))
but the outcome is the following:
The function corr is not supported by the origin data JD-D2
i have tried to compute this on report too and i have the same error, but it works only with data produced by SQL query, if i put dimensional member in the same report query i have the same error 
How i can compute on dashboard? 

Thanks

------------------------------
valerio pascarella
------------------------------

Hi,

if we talk about a simple list I would then choose table or crostab as visualization in a dashboard.

If you want to concatinate real sentences like "Revenue for Rome is 4.1M€ in 2010" that's only possible in Report Studio as far as I know.

But I'd like to go back to your request regarding the corr() function. What is your actual datasource? Is it a PowerCube, DMR-Model or a Dynamic Cube? If it's a dynamic cube you can create calculated measures on the cube level and on the database level. If it's a measure on the database level, you can then use the corr function.

Hi all,
I'm trying to compute correlation between two variables, in cognos dashboard, as follows:
corr( tuple(value;variabile1); tuple(value;variabile2))
but the outcome is the following:
The function corr is not supported by the origin data JD-D2
i have tried to compute this on report too and i have the same error, but it works only with data produced by SQL query, if i put dimensional member in the same report query i have the same error 
How i can compute on dashboard? 

Thanks

------------------------------
valerio pascarella
------------------------------

Hi,

if we talk about a simple list I would then choose table or crostab as visualization in a dashboard.

If you want to concatinate real sentences like "Revenue for Rome is 4.1M€ in 2010" that's only possible in Report Studio as far as I know.

But I'd like to go back to your request regarding the corr() function. What is your actual datasource? Is it a PowerCube, DMR-Model or a Dynamic Cube? If it's a dynamic cube you can create calculated measures on the cube level and on the database level. If it's a measure on the database level, you can then use the corr function.

Hi all,
I'm trying to compute correlation between two variables, in cognos dashboard, as follows:
corr( tuple(value;variabile1); tuple(value;variabile2))
but the outcome is the following:
The function corr is not supported by the origin data JD-D2
i have tried to compute this on report too and i have the same error, but it works only with data produced by SQL query, if i put dimensional member in the same report query i have the same error 
How i can compute on dashboard? 

Thanks

------------------------------
valerio pascarella
------------------------------

Hi Vincenzo,

depending on what you want to create exactly, there are several solutions. I built a sample based on a repeater that simply groups by "Retailer site" and put text items and the data items in a block. That's it.

Result:

If your required layout is more complex you can also look at the repeater table or the list + text item in combination with a master-detail relationship. It's hard to predict what you really need for your report.

Hi,

if we talk about a simple list I would then choose table or crostab as visualization in a dashboard.

If you want to concatinate real sentences like "Revenue for Rome is 4.1M€ in 2010" that's only possible in Report Studio as far as I know.

But I'd like to go back to your request regarding the corr() function. What is your actual datasource? Is it a PowerCube, DMR-Model or a Dynamic Cube? If it's a dynamic cube you can create calculated measures on the cube level and on the database level. If it's a measure on the database level, you can then use the corr function.

Hi all,
I'm trying to compute correlation between two variables, in cognos dashboard, as follows:
corr( tuple(value;variabile1); tuple(value;variabile2))
but the outcome is the following:
The function corr is not supported by the origin data JD-D2
i have tried to compute this on report too and i have the same error, but it works only with data produced by SQL query, if i put dimensional member in the same report query i have the same error 
How i can compute on dashboard? 

Thanks

------------------------------
valerio pascarella
------------------------------

Hi Vincenzo,

depending on what you want to create exactly, there are several solutions. I built a sample based on a repeater that simply groups by "Retailer site" and put text items and the data items in a block. That's it.

Result:

If your required layout is more complex you can also look at the repeater table or the list + text item in combination with a master-detail relationship. It's hard to predict what you really need for your report.

Hi,

if we talk about a simple list I would then choose table or crostab as visualization in a dashboard.

If you want to concatinate real sentences like "Revenue for Rome is 4.1M€ in 2010" that's only possible in Report Studio as far as I know.

But I'd like to go back to your request regarding the corr() function. What is your actual datasource? Is it a PowerCube, DMR-Model or a Dynamic Cube? If it's a dynamic cube you can create calculated measures on the cube level and on the database level. If it's a measure on the database level, you can then use the corr function.

Hi all,
I'm trying to compute correlation between two variables, in cognos dashboard, as follows:
corr( tuple(value;variabile1); tuple(value;variabile2))
but the outcome is the following:
The function corr is not supported by the origin data JD-D2
i have tried to compute this on report too and i have the same error, but it works only with data produced by SQL query, if i put dimensional member in the same report query i have the same error 
How i can compute on dashboard? 

Thanks

------------------------------
valerio pascarella
------------------------------