HostWeb Forums » Microsoft Databases » microsoft.public.sqlserver.olap » Any takers on this issue with calculated member

Topic: Any takers on this issue with calculated member

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 6/4/2008 8:52:01 PM

By: Anonymous

Hi,

I need to create a calc member within the Sales cube that would give me the
"Total Sales Price" for 3 particular products.

The calc member works fine with 1 product: ([Measures].[SALES AMT],
[Product].[Prod Line].&[A])

With Multiple products: No error while saving. But #VALUE! error when browsing
the cube: "The function expects a string or a numeric expression for the
argument. A tuple set expression was used."

([Measures].[SALES AMT], { [Product].[Prod Line].&[A]), [Product].[Prod
Line].&[B]), [Product].[Prod Line].&[C] })

The numeric expression is the measure itself: [Measures].[SALES AMT]. I am
not sure why it is not liking the set of products.

Please suggest the correct alternative.

Thanks.

Replies below ↓

Replies

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 6/5/2008 2:18:41 AM

By: Lior Cohen Amikam

Re: Any takers on this issue with calculated member

the calc member u need is :

with member [Total Sales Price A, B & C]
sum(
{ [Product].[Prod Line].&[A], [Product].[Prod Line].&[B],
[Product].[Prod Line].&[C] }
,[Measures].[SALES AMT]
)

"Prasad" <Prasad@discussions.microsoft.com> wrote in message
news:7472284B-7BE4-4EF6-911F-006C3E686F82@microsoft.com...
> Hi,
>
> I need to create a calc member within the Sales cube that would give me
> the
> "Total Sales Price" for 3 particular products.
>
> The calc member works fine with 1 product: ([Measures].[SALES AMT],
> [Product].[Prod Line].&[A])
>
> With Multiple products: No error while saving. But #VALUE! error when
> browsing
> the cube: "The function expects a string or a numeric expression for the
> argument. A tuple set expression was used."
>
> ([Measures].[SALES AMT], { [Product].[Prod Line].&[A]), [Product].[Prod
> Line].&[B]), [Product].[Prod Line].&[C] })
>
> The numeric expression is the measure itself: [Measures].[SALES AMT]. I am
> not sure why it is not liking the set of products.
>
>
> Please suggest the correct alternative.
>
> Thanks.
>
>

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 6/8/2008 8:52:02 AM

By: Anonymous

Re: Any takers on this issue with calculated member

Thank You. This works like a charm!!

"Lior Cohen Amikam" wrote:

> the calc member u need is :
>
> with member [Total Sales Price A, B & C]
> sum(
> { [Product].[Prod Line].&[A], [Product].[Prod Line].&[B],
> [Product].[Prod Line].&[C] }
> ,[Measures].[SALES AMT]
> )
>
>
> "Prasad" <Prasad@discussions.microsoft.com> wrote in message
> news:7472284B-7BE4-4EF6-911F-006C3E686F82@microsoft.com...
> > Hi,
> >
> > I need to create a calc member within the Sales cube that would give me
> > the
> > "Total Sales Price" for 3 particular products.
> >
> > The calc member works fine with 1 product: ([Measures].[SALES AMT],
> > [Product].[Prod Line].&[A])
> >
> > With Multiple products: No error while saving. But #VALUE! error when
> > browsing
> > the cube: "The function expects a string or a numeric expression for the
> > argument. A tuple set expression was used."
> >
> > ([Measures].[SALES AMT], { [Product].[Prod Line].&[A]), [Product].[Prod
> > Line].&[B]), [Product].[Prod Line].&[C] })
> >
> > The numeric expression is the measure itself: [Measures].[SALES AMT]. I am
> > not sure why it is not liking the set of products.
> >
> >
> > Please suggest the correct alternative.
> >
> > Thanks.
> >
> >

Page 1 of 1 Pages