geting the UNIQUENAME fom a string

Does anyone have an idea how to get the UNIQUENAME of a member from ther dimesion date given a determined value.

For example in Adventure Works

Val: 2004

UNIQUENAME: [Date].[Calendar].[Calendar Year].&[2004]

Thanks!!

Here is an example showing how to retrieve the unique member name or the key value associated with the current member:

WITH

MEMBER MEASURES.[UniqueName] AS

[Date].Calendar.CurrentMember.UniqueName

MEMBER MEASURES.[KeyValue] AS

[Date].Calendar.CurrentMember.Properties("Key")

SELECT

{[Date].[Calendar].[Calendar Year].&[2004]} ON COLUMNS,

{MEASURES.[UniqueName],MEASURES.[KeyValue]} ON ROWS

FROM [Adventure Works]

HTH,

- Steve

Get zodic sign in sql server

I have a field in table A named tbl_dob.It is date of birth of member. I want to find zodic sign from this tbl_dob.How I get it.Please help me.

You'll have to create a table to hold the zodiac signs and their date ranges. You can then join to this table to find which sign the date falls into.

sql

Get PageNumber in the body

The PageNumber member can be used only in page header and footer. Because Globals can be used only there.
Is there anyway to get page number in the body?

Thank you very much!

No, there is no way to get the page number in the body of the report unless you somehow have your own counter (maybe a group CountRows() and you page break on group).