ahhhh outer apply off course exactlt the prod i needed. thanks.

Yep appreciate the indexing aspect and that was next thing to tackle. I just know the sub query in the select isnt the most elegant way to perform this and...

The status conditions have yet to be decided but will be based on the difference in days between ReturnDate and DateTimeScan so the issue im finding is getting the optimum way...

Sorry 

its been so long since I did this last that im just wondering if there are any new methods of achieving this end goal of serving up ssrs reports...

Thanks

If I'm understanding you correctly my fact table has Item Count (always 1), Item Price & Item Tax in it and the associate keys to dimension DimCustomer, DimDate, DimOrderStatus, DimOrderType...

That's a good read thanks and I'm currently dissecting it. It looks to be what I'm after but I'm not sure how to apply it to my model. Our order...

Thanks

Im using an embeded datasource. You are right the credentials haven't been configured, because its SSAS i don't know what to configure them as. When im configuring a SSRS datasource...

Thanks

yes i thought about both options you mention, but as a user can favourite many items I thought it better to create FactFavourite table that includes all items favourited with...

oh definitely taking that on board but literally just started developing in SASS this week so I'll revisit this again when I'm more familiar with cubes. it performs ok just...

It did thanks, the first option worked well. Im not knowledgeable enough on the 2nd and 3rd just now so ill go with 1 thanks.

Ahhhhh how stupid am i, off course? taking in too much information at the one time. that makes sense. thanks, guys 🙂

Yes starting to understand that. I guess I'm miss-interpreting Kimballs explanation

"“Null-valued measurements behave gracefully in fact tables. The aggregate functions (SUM, COUNT, MIN, MAX, and AVG) all do the “right...

"As each customer will only likely have one referral source, it should be safe as long as there is correlation. In this case, I would be willing to bet there...

Yes i thought about that which was my thinking with having the raw tables and the staging tables. for example to build the DimCustomer i pull the transactional data into...

Yes im updating the staging tables directly, should i be??. this project really is a proof of concept to get the business invested into a DW and cube solution im...