Can I source a ReportNet report from an MSAS cube? I can do this using
Cognos Power Play, but can't seem to figure out how to use ReportNet
and/or Framework manager.

Thanks!

Mark

mark.dalton (AT) ceridian (DOT) com wrote:
I don't know. Ask Cognos. They should give you the right answer.

regards

Frank

Cognos ReportNet should introduce MS AS in the framework with the next
version (V2 in September in France).
Today the only way I know to use ReportNet and MS AS is to create a stored
precedure that you can declare in a framework, so usable with ReportNet.
How to do that :
1/ create a linked server pointing on your OLAP server (LINK_OLAP in the
following example).
2/ create your stored procedure containing something like that

select * from openquery
( LINKED_OLAP, 'select { measures.[unit sales] } on columns,
non empty nest( nest( [customer location].[country].members,
[gender].members ), [product category].[bread].children ) on rows
from sales ')

3/ declare this stored procedure in your framework and then your can use it
in ReportStudio.

Not the top but I use that and it works. For more information about that,
just have a look on the SQL help : 'Passing Queries from SQL Server to a
Linked Analysis Server'

"mark.dalton (AT) ceridian (DOT) com" wrote: