Stored procedures in SSAS are implemented via assemblies (and they're different from what you're thinking of.)

The question here, is what are you looking to do? Why are you looking to...

Before creating subscriptions, you need to ask yourself if you need to run the report with the users access. If all users run reports with the same access, then you...

Yes it's possible, but it's unclear exactly what you're asking for. Please clarify and add some specifications (i.e. data source, final result, etc.)

You'd have to format the hours yourself. I'd have to try it out, but something like:

= Format(Fields!OutboundHours.Value / 3600, "#")

+ ":"

+ FormatDateTime(DateAdd("s",Fields!OutboundHours.Value,0),"mm:ss")

should work. Didn't check the syntax. Hopefully you...

As I understand your query, you want to simply suppress the parameter query from executing, if you've already supplied a value. This assume that the value is correct.

As far as...

Very similiar in MSRS:

[Code]

=FormatDateTime(DateAdd("s",Fields!OutboundHours.Value,0),"HH:mm:ss")

[/Code]

Here's some references for you:

http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx

http://msdn.microsoft.com/en-us/library/aa262710(VS.60).aspx

What were you trying to do?

What you're detailing is certain possible, the details are in the implementation.

I think what you want id:

- You have a "fact" table, with purchases (and otherwise keyed).

- You want to...

"future-is-back" please don't double post (http://www.sqlservercentral.com/Forums/Topic506512-147-1.aspx)

Since you've obviously seen these posts, these are all good references. Once you've got your cube up and running, you'll need a front end. Excel...

You really need to provide some details when posting this type of query. Exactly what message are you getting when you attempt to run the query? Was there anything in...

Just to confirm for people:

MDX indeed DOES NOT support the datetime format in the manner you may be expecting. To understand that, you'll notice that there are MDX fuinctions like...

Basically, Report Services is a "web product" that renders data in HTML (through IIS) and Analysis Services is a OLAP product (calculation engine with data storage) that optimizes the calculations...

As a reminder, remember that their are separate rendering engines for the differfent output types, although there's overlap on the code (they share some components). So sometimes you'll find a...

In general, I'd say yes, there should be separate items. If something can be different sizes, then generally they can't truely be the same thing.

The exception to this is when...

After rereading your original post, I realised your dimension has 33 million records (when I originally assumed you were talking about the data table).

This is indeed a very large dimension....