I can't use calculated members in data mining.
I found information that I can use derived-member.
I would like to calculate Sum(numberOfItems) in source column. Is it
possible?

Thanks all for help!

Simon

I'm not sure how exactly you model looks like. My first thought is to have a
view defined in your data source and a filed of that view should be
'Sum(numberOfItems). Based on that view, build a relational model.

Hope this helps...

--
Raymond Balint [MS]
This posting is provided "AS IS" with no warranties, and confers no rights.



"Simon Abolnar" <Simon.Abolnar (AT) tscng (DOT) net> wrote

I will better describe my situation:

I have to calculate average sugar of grape received by different date.
In SQL View I calculate: sugar*quantity (column)
In OLAP I have member: quantity (which is sum of all quantity)
I can easely calculate average sugar as:
[Member].[sugar*quantity]/[Member].[quantity]

How can I do this by using derived member?
Is there a way to use calculate member in datamining?

Thanks for help,

Simon




"Raymond Balint" <raymondb (AT) online (DOT) microsoft.com> wrote

I assume you want to build an Olap mining model. However you cannot use
calculated members in Olap mining models - this is a limitation of Analyses
Service 2000.
You will have to use a relational mining model on top of a view.

--
Raymond Balint [MS]
This posting is provided "AS IS" with no warranties, and confers no rights.



"Simon Abolnar" <Simon.Abolnar (AT) s-tsc (DOT) ng.edus.si> wrote