If you have to do a lot of time-based calculation then there is no better place to start than by setting up a date tool dimension:

http://sqlblog.com/blogs/marco_russo/archive/2007/09/02/datetool-dimension-an-alternative-time-intelligence-implementation.aspx

It's one of the first...

MDX isn't magic, you will need to do the groundwork in the structure of your cube first. My thought is that you will need to utilise a many to many...

The simplest answer is to create a new attribute, call it "Day of Week" or some such and don't have it in a hierarchy or give it a composite key....

I think that this technique (using AdventureWorks as an example) does what you are looking for. You should be able to adapt it to your needs (providing you have a...

SQLRNNR (9/4/2015)

---

PB_BI (9/4/2015)

---

Nice question - BOL says that sysprocesses will be removed from future versions and to use sys.dm_exec_connections, sys.dm_exec_sessions, and sys.dm_exec_requests instead (https://msdn.microsoft.com/en-us/library/ms179881.aspx). That's what I love about QOTD...

Nice question - BOL says that sysprocesses will be removed from future versions and to use sys.dm_exec_connections, sys.dm_exec_sessions, and sys.dm_exec_requests instead (https://msdn.microsoft.com/en-us/library/ms179881.aspx). That's what I love about QOTD - I...

On the right hand side of the screen in the dimension editor there is a window that shows a view of the tables (as they are in the DSV) that...

edwardwill (8/3/2015)

---

Toreador (8/3/2015)

---

Hardly an abject failure, he just got one word wrong.

Though I was looking for a "none of the above" answer to "which of these queries will do this",...

The simplest answer...

Using Visual Studio, connect directly to your cube (it will say [Online] next to any tabs you have open). Have a look in the dimensions, are the descriptions there at...

Jonathan Mallia (7/23/2015)

---

Hi everyone,

I have a Count measure that is simply counting over a set as follows:

MEMBER Measures.[Count Customers]

AS COUNT( EXISTING CurrentCustomers )

This query returns the correct result but is...

qur7 (7/21/2015)

---

Based on what I have searched, for HA fail over cluster and for DR just schedule the backup and restore of SSAS databases. one thing that would come in...

kamamusic (7/15/2015)

---

Hi,

I agree with you but... I don't have control on the Server B, I have only a login for SSAS and server are both out of domain.

I think the...

kamamusic (7/10/2015)

---

Dear all

I am migrating from server A to Server B an entire SSAS project with different cubes. The server A will remain my deployment server and the new server...

saravanakumar.G (7/9/2015)

---

Hi,

How to convert Oracle @ISMBR function into SSAS MDX Query?.

I tried like

IIF(

Count(

Intersect(

{MemberRange([New York],[New Hampshire])},

...