In parent-child dimensions. I define unary operator column in th
property of dimension attribute(usage = parent). And it run
normally.

But, in a regular dimension. I define unary operator in the propert
of dimension attribute (usage = key). AS will be shut dow
automatically when processing cube.

How to define unary operator in a regular dimension?

PS: My question is focus on SQL Server 2005

thanks

I'm glad someone else is having this problem. We have some regular
non-parent-child dimensions that have custom rollups and unary operators
defined in their respective dim tables.

The dims will process, eventually, but when going to browse the dim data
(not even included in a cube yet), the Analysis Services service shuts itself
down. When added to a cube, the process runs for a very long time, and
again, the service shuts itself down.

Any input welcome.

Thanks!

- Phil


"ivan" wrote:

As far as I have been able to tell the "Browse dimension" functionality
is a bit of a fake. (sorry MS ) It actually seems to run SQL queries
against the relational source (or maybe some hybrid approach). So I
never really trust the what the dimension browser tells me outside of
the context of a cube.

Can you try running SQL Profiler while browsing to the dimension to see
what (if any) SQL queries are being executed against SQL Server. This
may give you a hint as to what data is coming back to AS to cause it to
trip up.

I had a 10,000 member account table a couple of years ago for a large
client with 6-7 levels that used unary operators without any problems (I
think on SP3)

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Hello, Gosbell
You say that "I had a 10,000 member account table a couple of year
ago for a large client with 6-7 levels that used unary operator
without any problems (I think on SP3)

Does it work in SQL 2000
I beleive that unary operator is work fine in SQL 2000 no matte
parent-child or non parent-child dimension but SQL 2005 (CTP June)

I try to define unary operator in SQL 2005, parent-child is wor
fine but non parent-child...^^

Hi Darren -

Forgive me for omitting a major fact, I'm having this problem in Yukon only,
like Ivan. He was better at communicating it than me.

Our parent child dims that are similar in complexity to the ones you mention
are fine in 2000 and Yukon, and our regular dimensions with unary operators
and custom rollups are fine in 2000. It's our regular dims with unary ops
and custom rollups that are failing in Yukon. They'll process, but can't be
viewed. Trying to view them causes the service to stop. Also, when included
in a cube and when trying to process, the process fails because the service
stops then as well.

Has anyone else seen this symptom?

(Darren, thanks again for your attention.)

- Phil


"Darren Gosbell" wrote:

Yes - that makes the situation slightly different

If you have access to them you are probably better to post
questions/issues relating to AS2005 in the beta newsgroups.

However, as you have posted here I am assuming that you may not have
access. I did find the post below, which indicates that unary operators
on regular dimensions was a feature that was only added very recently
CTP16 (which I think is the Sep CTP?)

If you are using the September CTP and are still having trouble you can
log an issue with at the MSDN Product Feedback centre at
http://lab.msdn.microsoft.com/produc...k/default.aspx

HTH

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Unfortunately, I try to do it on CTP Sept. It's not working fin
still

I try to use "Business Intelligence Wizard" to specify a unar
operator

And there is a description abou
"Specify a unary operator t
replace the default aggregation that is associated with members in
parent-child hierarchy.

And I choose a regular dimension, there is a warning messag
"[b:fb6b573002][color=darkblue:fb6b573002]The wizard cannot find a
attribute in the XX02 dimension whose Usage property is set t
Parent. Before defining a unary operator, first create a parent-chil
hierarchy[/color:fb6b573002][/b:fb6b573002]."
in which "XX02" is a dimension name(regular dimension)

thanks for your suggestion

Using Sept. CTP and Adventure Works sample cube, a unary operator on the
Geography dimension GeographyKey attribute worked fine, as follows (I
chose Geography because it is a regular dimension with strong hierarchy
relationships):

1) Added "GeoKeyUnaryOp" Calculated Column to DimGeography table in
Adventure Works DW Data Source View, defined as (note that Birmingham,
AL has a key of 280):
then '-' else '+' end
2) For GeographyKey Attribute (of Type Key), defined
UnaryOperatorColumnProperty as "GeoKeyUnaryOp"

3) Updated and reprocessed Adventure Works cube

4) Browsed "ResellerSalesAmount" measure by Geography. Under
USA/Alabama/Birmingham/35203, the amount (about $20K) now appears
negative, so Alabama toral is now only $4K.

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi Deepak
thanks for your sample and steps
I try to do your sample step by step
and I try to do it in my project
All of them are work fine. :

I find that it's work fine if I dirrectly defin
UnaryOperatorColumnProperty
But if I use "Business Intelligence Wizard" to specify a unar
operator. There is still a warning message
"The wizard cannot find an attribute in the XX02 dimension whos
Usage property is set to Parent. Before defining a unary operator
first create a parent-child hierarchy."

thanks

Maybe the BI gurus from MS can confirm this, but it sounds like the
Business Intelligence Wizard is only wired to add a unary operator to a
parent-child dim?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***