You can do this fairly easily in Excel itself.....Connect to the cube and create a pivot table with your required dimensions. Pick an arbitrary measure and then right click on...

I don't know if there's a way to parse xml column in SSAS directly, but you could create a linked server to your AS instance on a SQL instance and...

You used the wizard didn't you? 😀 I think what's happened is that the wizard looks at your dsv and tries to determine what are fact tables (measure groups in...

You need to create a set of the two members to get the intersect and then sum it. Here's an example on adventure works for bike sales in the UK:

WITH...

You could achieve this if you used an expression in your dataset and returned the appropriate columns based on the parameter. There's more info on an implimentation of that sort...

You can have one dataset and multiple charts, no duplicate code "galore" there. It's just a suggestion for a workaround, I have no idea of your individual situation so don't...

Yeah SSRS is a bit tricky in that respect.

I suppose what you could do is have three charts based on the different columns and then show/hide them based on...

Using LastPeriods with a parameter for different levels will give you different result sets depending on the level.

Consider the following two queries:

SELECT

[Measures].[Reseller Sales Amount] ON 0,

LASTPERIODS(2,[Date].[Fiscal].[Fiscal Quarter].&[2008]&[4]) ON 1

FROM

[Adventure...

It's a bit of a shift in thinking when you're used to something else. I really cannot recommend more to read The Data Warehouse Toolkit by Kimball. It will make...

Guitar_player (9/16/2014)

---

Yes, i thought the same and i have implemented that with Date only..but the problem is with Members ...The member selection of Date is dynamic here so i have...

Guitar_player (9/15/2014)

---

Hi,

Yes i think i am nearer but i am struck somewhere like " .Parent.Children " was used on a Member.

As in my scenario the...

Data can be taken from any database source - it's generally a good idea for it to be a data warehouse but it doesn't have to be. ROLAP is a...

Yeah, in out of the box AdventureWorks the Calendar hierarchy is Year>Quarter>Month>Date. For this example I added in week to make it Year>Quarter>Month>Week>Date.

The fact that you get the entire...

SQLSACT (9/15/2014)

---

Am I correct in that ROLAP is when your data warehouse is stored as normal Relational SQL Database within your instance and MOLAP is when your data warehouse is...

You could do this using .Parent.Children. So you are saying "for this date, show me the parent week and then show me the children of that parent week". For example,...