Imke Cronje (3/3/2013)

---

Hi guys,

I need some help with attaching an AdventureWorks analysis services database. I am trying to attach it but am getting the following error:

The database folder '<folder>\AdventureWorks SSAS.database'...

If you have rows but null columns then it's because the calculated member is silently erroring, and that will be indirectly related to the multiple parameter values.

If this is working:

STRTOSET...

StrToValue ( @SelectionGeographie + ".Hierarchy.Currentmember.Uniquename" )

StrToValue( @SelectionActivite + ".Hierarchy.Currentmember.Uniquename" )

...

You want to get all data even though you have filtered the data? That doesn't really make sense. If you want all the data, don't filter it.

Can you explain a...

yuvipoy (2/27/2013)

---

Hi,

I am having a requirement of taking the MAC Address using SSRS is it is possible to take?

My Requirement:

To take and keep the mac address of each user...

Thanks, this was a useful excercise. I didn't get 6, 13 and 15 right according to your answers.

6: I've never used ##globals. I know in procedural languages globals are...

PowerPivot charts are also great visualisations, and you can use them alongside pivot tables for those who want to see the numbers. It's also just an Excel (or SharePoint) addon,...

Not directly in SSRS.

If you create your own ASP.NET page with the report control you can use a text box with AJAX or similar technology to achieve this effect.

By...

This is the exact error you would get if the parameter's datatype is Integer. Double check that.

Another thing you can try is using

like '%' + Cast(@ID as nvarchar(20)) +...

Hi Niha,

Can you please show the errors here.

Datediff will show you the number of intervals. If you want days, leave it as days.

If your input dates, Fields!Date.Value & Fields!Date2.Value...

Glad that you sorted it out.

Strange that the only change you made to fix it was removing some comments, that shouldn't have made any difference.

Anyway, strange things happen.

If this is MySQL then this isn't really the right place, this site is for Microsoft SQL Server, but the first question I would ask you are what tools are...

Your syntax looks fine, assuming these exist:

[Geography].[State hierarchy].MEMBERS

[Measures].[Test]

I tried it on Adventureworks 2005 changing it slightly to match an existing Hierarchy and Measure and it debugs fine (by pressing F5...

And this one:

=cdec(DateDiff(DateInterval.Day,Fields!Date.Value,Fields!Date2.Value))*(-1)

The DateDiff function "Returns a Long value specifying the number of time intervals between two Date values."

DateInterval.Day is the Day member of the DateInterval collection, so the DateDiff function...