How get flatten query

#1

#2

select
{
[Measures].[Sales]
} on columns,
{
[Company].Members *
[Network].Members *
[Name].Members
} on rows
from MyCube

Bartosz Gorzynski wrote:

Quote:

#3

Not works - i get message "Unable to open cellset.
Formula error - duplicate dimensions across (independent) axes -
in a <set> base objectMyDimension"

OLAPMonkey (http://olapmonkey.blogspot.com/) napisal(a):

Quote:

select
{
[Measures].[Sales]
} on columns,
{
[Company].Members *
[Network].Members *
[Name].Members
} on rows
from MyCube

Bartosz Gorzynski wrote:

I have in example one dimension with 3 levels
COMPANY (ex. TR,ZR)
NETWORK (ex. E,B)
NAME ( ex. steve, John)

and Sales fact

i want to get result like

Company |Network|Name | Sales
--------------------------------
TR |E |steve | 100
ZR |B |john | 200
TR |B |adam | 300

to export data to table

how can i get this ?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How get flatten query

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

How get flatten query - 06-15-2005 , 06:44 AM

Re: How get flatten query - 06-15-2005 , 10:12 AM

Re: How get flatten query - 06-16-2005 , 03:13 AM