Okay; I wanted to make sure I wasn't losing it or...

In SSMS, I have the partitions as well. See attached screen capture.

It makes me think that this changed since SSAS 2005 to allow for partitions in Standard edition.

Rob

Charles,

But my situation is that I have 2008 R2 Standard edition on the production server, but when I open the production SSAS database directly through BIDS/VS I see partitions on...

I don't think so, but I double checked. I connected to the SSAS server with SSMS, right clicked on...

Look at using a SQL formatter (such as: http://poorsql.com/ ) and wrapping your code in tags (located to the left of the editor textbox) to make your posts more...

A quick Bing search finds:

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

http://www.dbi-services.com/index.php/blog/entry/sql-server-2012-new-features-for-reporting-services-ssrs-

HTH,

Rob

Chrissy321 (10/22/2012)

---

I'd like to make it easier for my users to access the SSRS root folder.

Is it possible to replace the existing URL http://MyServerName/Reports so that if they...

kmiles (10/20/2012)

---

In SSRS 2008, I have a linked server setup to SugarCRM using the 64 bit Mysql ODBC connector. Openquery is not needed (and does not work) when setting up...

Everyone I've ever run into says its a bear. Once you get it setup though, you get past the "double hop" issue. I've always had trouble with it....

It looks like you are doing this in SSMS or browsing your cube in VS. Just drag the measure (Sales Amount column header) off of the browsing pane.

HTH,

Rob

The request for the DDL was so we could see the tables and have SOME idea of what you're talking about.

Sorry, I'm unable to be of help.

Rob

Can you insert the lists into SQL Server temp table(s)/table variables and then do what ever joining you need?

Just asking,

Rob

ByronOne (10/17/2012)

---

I have a SQL table that contains information on visits to our centre. The table contains a number of columns but the ones I'm interested in are: CentreName, DateOfVist...

deepa lekshmi (10/16/2012)

---

Hi All,

We require to convert a list of SPs to SSIS packages. Most of the SPs do the below steps:

1. create a table and insert data into that...

=DateAdd("d", 15, Now)

HTH,

Rob