Hi MTY,

"aggregate column which is more than key columns"

I think what you mean is a measure column which is duplicated across rows. The Kimball term for this situation is: the...

Hi,

the 2 error messages indicate that the calculated measure(s) are incorrectly written.

MDXScript(Cube Name) (,14) The dimension ‘[LAST MONTH WITH DATA]’ was not found in the cube when the string,...

Hi Duda, if cycle1 attributes work but but cycle2 attributes don't, please check the attribute relationships of between cycle2 attributes in the cycle2 hierarchy, especially the relationship from Year2MonthNumber to...

Hi Rick,

1. If the week attribute is in yyyy-ww format, we can use datepart() for [This Week]:

with member [Transaction Date].[Week].[This Week] as

StrToMember("[Transaction Date].[Week].&[" + cstr(datepart("yyyy",now())) +

"-" +...

Thanks Rick.

We can create a calculated member such as Yesterday and Last Month like this:

with member [Transaction Date].[Date].[Yesterday] as

members("[Transaction Date].[Date].&[" + Format(DateAdd("d",-1,now()),"yyyy-MM-dd") + "]")

select [Transaction Date].[Date].[Yesterday] on rows,

...

Hi erin, I sent part 2 on 31st December so hopefully it would be published soon.

Vincent

All, thank you for all your comments. Sanjarani, for learning SSAS my book is not the right one. My book is about building a data warehouse and BI, so the...

Yes you are right Dudley, we can create the product dimension row based on the product ID to handle late arriving dimension data.

Great article Brian. Very structured. Thanks for spending the time writing it.

Thank you for sharing your view Abdel.

Kind regards,

Vincent

Hi Rick, I create the date dimension from scratch. I never modified the SSAS project files directly (except for a few rare cases), I always use BIDS* to edit/create the...

You are right Abdel, with micro-batch or near real time ETL, data warehouses now have new functions. It’s now used not only for analysis, but also for operational reporting and...

Hi Mike, using named queries gives us more flexibility, i.e. we can modify the cube without modifying the database structure. Using views gives performance improvements (processing time) if there are...

Dear all, I'd like to thank you all for reading this article and also for your comments.

Hi Mike, when different ranges are required we can create several Named Queries with...

Hi Vijay, the ODS key is a surrogate key, i.e. sequential integer beginning with 0. For example: 0, 1, 2, 3, ... etc.

Data firewall is a collection of data quality...