Can ou post all of your query - also the column name is [stage] right?

Mack

REPLACE(Stage,'Closed Won','Awarded')

Mack

Try this and let me know if it works

SELECT

{[Measures].[Operational Transactions Count]} ON COLUMNS,

{[Date].[Hierarchy - Fiscal].[Fiscal Week].&[2012]&[48]} ON ROWS

FROM

(SELECT {[Financial Transaction Channel].[Transaction Channel Desc].&[POS],

[Financial Transaction Channel].[Transaction Channel Desc].&[CONCIERGE]} ON COLUMNS

FROM...

Hi,

That's fine if you are writing all the MDX yourself but not ideal if you are using an ad-hoc query tool (like pivot tables in Excel or ProClarity or XLCubed...

This maybe more what you are after as it will give you a comma seperated list of the children for the All level

with member [Measures].[member name] as

IIF([Dimension].[Hierarchy].Level.Ordinal = 0

, Generate([Dimension].[Hierarchy].[All].Children

,[Dimension].[Hierarchy].CurrentMember

,',')

,...

Not sure this fully answers you question but could you create an extra column in you MDX statement with the name in such as

with member [Measures].[member name] as

[Dimension].[Hierarchy].CurrentMember.Name

Select...

I would say that you've posted this in the SSAS bit of the forum not the Report Builder/Reporting Services bit. You might get more response there

Mack

Try

OpenAmountDomestic = 0 ? 0 : DATEDIFF( "d", DueDate , GETDATE() )

I can't test it for you but it should be along those lines

Mack

Try something along the lines of

With Member [Measures].[Thing Count YTD] As

Sum(YTD([Effective Date].[Year-Week].CurrentMember)

, [Measures].[Thing Count] )

SELECT

[Measures].[Thing Count YTD] ON 0,

[Effective Date].[Year-Week].[Week].[2013 Week 6] ON 1

FROM

[Cube]

Mack

Try something like

with set [MIs] as

Filter([Marca_Modello].[Codice Merceologia].Members

,Left([Marca_Modello].[Codice Merceologia].[All Marca_Modello].CurrentMember.Name,2) = "MI")

SELECT

[MIs]

ON COLUMNS,

[Measures].[Importo Venduto] ON ROWS

FROM Vendite

WHERE [Anno].[All Anno].[2012]

Mack

Not sure there is a great amount of detail to go off but I would create two measures - # of contracts started this year & # of contracts finished...

What bit don't you understand?

If the answer is all of it then you may need to look at TSQL tutorials online...

Mack

hmmmmmm sounds like restarting the service is your best option at this point

Looks like no-one else is using it tho judging from the DSVs

Mack

Use the DMVs to check if there are any large queries running or any long running connections and kill them. SSAS will wait for large queries to finish before...

Restarting the service should do this

You could see if there are connections to the server that you can kill. Use the DMVs to find a connection and then kill...