I have "dbo"."tblEnrolmentFact"."StudentID" in my source Column.

Can I replace "dbo"."tblEnrolmentFact"."StudentID"
to following statement:-

"select studentid from tblEnrolmentFact
group by studentid
having count(*) = 1"

Can I get StudentID from fact table in Calculated Members?

Please advice. Thank you



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Your specific approach won't work, but there is a way to do this. What you
can do is create a view in the database that does this for you and just
build the dimension off that view.

I'm not sure if the second part of your post is related to the first one or
not. You can't reference StudentID from a calculated member, unless you
create a student dimension and make StudentID a member property of some sort
(either the key or a separate property all together) You can only reference
the StudentID field in the database as a source for a measure.

Sean


--
Sean Boon
SQL Server BI Product Unit

Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.

"Ling" <anonymous (AT) devdex (DOT) com> wrote