MS SQL Server OLAP - Getting Measures in Rows

Author

Getting Measures in Rows

Denver

2006-01-26, 4:58 pm

Is there anyway of getting a list os the measures to appear in the rows
as oppose to the columns. I would like to do this so I could build a
list to display in a Parameter box in reporting services. I'm guessing
I use a SettoStr or SettoTuple type command but trial and error is
getting me nowhere

Thanks in advance

Denver

Kevin

2006-01-26, 4:58 pm

I'm really pretty new to Analysis Services myself so I may be of no
help......

This returns measures as rows:

SELECT * FROM OpenRowset('MSOLAP',
'DATASOURCE=MachineN
ame; Initial
Catalog=CatalogName;
',
'SELECT Measures.members ON ROWS,
[Time].members ON COLUMNS
FROM [DatabaseName]')

This returns measures as columns:

SELECT * FROM OpenRowset('MSOLAP',
'DATASOURCE=MachineN
ame; Initial
Catalog=CatalogName;
',
'SELECT [Time].members ON ROWS,
Measures.members ON COLUMNS
FROM [DatabaseName]')

Perhaps I'm misunderstanding your question??

Denver wrote:
> Is there anyway of getting a list os the measures to appear in the rows
> as oppose to the columns. I would like to do this so I could build a
> list to display in a Parameter box in reporting services. I'm guessing
> I use a SettoStr or SettoTuple type command but trial and error is
> getting me nowhere

Deepak Puri

2006-01-26, 4:58 pm

If you're using the OLE DB for OLAP provider, it should be
straightforward, as Kevin suggested. But when accessing AS 2005 via the
Analysis Provider, you may have to get more creative - see Chris Webb's
blog:

http://spaces.msn.com/members/cwebb...w.droptable.com ***

Sponsored Links