You can use log10(Measures.[i]your measure[/i])

More info here.

🙂

Have a look at the trim function I linked to above. You can specify characters that you need to have removed from the column. Either that or identify the guilty...

Hmmmm, what is the data type of the particular column in the database?

Sometimes users can put strange characters into varchars and nvarchars like tabs and carriage returns so you could...

Sounds like it might be an illegal xml character. What version of SSRS are you running and what version of Excel are you exporting to?

The Subscriptions table in your ReportServer database should have this information in the Details column.

Have a look at using VisualTotals as this will show a grand total of non-filtered members only.

This'll do it:

(DT_DBTIMESTAMP) (DT_DBDATE) DATEADD("D",-(DAY(DATEADD("M",1,GETDATE()))),DATEADD("M",1,GETDATE()))

To clarify, I'm converting the DATETIME into DATE to strip the time and then re-converting back to DATETIME.

🙂

You'll only be able to use parameters if the calculation is part of a query (say, one that's being run from SSRS).

Depending on exactly what your parameter is passing...

Grant Fritchey (12/11/2013)

---

If you understand that NUMERIC is a precision and then a scale, then you'd know that you need NUMERIC(10,5). Read up on it here. I'd also suggest, instead...

DECIMAL(10,5) 🙂

Ah ok, I didn't think of that. Perhaps if you created a measure group from your candidate data you could include a StartTermDateKey (or however you would name it) in...

Have a look at this[/url] article on writing dynamic XMLA for use within T-SQL. Using these methods you should be able to write something that will change your backup destination...

You don't need to use FILTER here. This would suffice:

select

{[Measures].[Reseller Order Count],[Measures].[Discount Amount]} ON 0,

{[Reseller].[Reseller Type].[Business Type].Allmembers} on 1

FROM

[Adventure Works]

WHERE

[Geography].[Country].&[Canada]

Your problem is described and diagnosed here: http://stackoverflow.com/questions/9668615/cant-reload-our-tfs-analysis-cube-due-to-snapshot-isolation

The fact that you have to ask that means that the answer is probably no 😀

So where are you trying to process from? SSMS? A BIDS project?

What is the specific...