Guitar_player (10/21/2014)

---

Yes , thats correct , but what if i have got the required columns in the main fact too which i need to use them in my reporting with...

Guitar_player (10/21/2014)

---

PB_BI (9/26/2014)

---

So you just need a count of the occupied rooms over the course of months, quarters and years?

I still don't think you need to distinctly count anything. Why...

A few ways you could do this........

A Merge/Merge Join transformation (http://msdn.microsoft.com/en-us/library/ms141775.aspx)

A Lookup transformation (http://msdn.microsoft.com/en-gb/library/ms141821.aspx)

Do the join in SQL in your source.

The first two would require duplication of your efforts...

There is a discussion on getting MODE in MDX here: http://blogs.adatis.co.uk/blogs/jeremykashel/archive/2012/03/19/mean-median-and-mode-in-mdx.aspx

and here:

http://www.sqlservercentral.com/Forums/Topic1536662-147-1.aspx

Okay, I think I misread your requirement before (sorry). Have a look at the following example, it shows the latest order date by Sales Channel and City in AdventureWorks. This...

No I think it's indicating that you need to create or open a .dax file in visual studio for it to work. Like the way there is no explicit "sql...

Have you tried the steps here:

http://daxeditor.codeplex.com/wikipage?title=Using%20the%20DAX%20Editor&referringTitle=Documentation

If so and still no joy, hit them up on the discussions page.

There are a couple of ways to achieve this, depending on the setup of your date dimension. Have a look at the YTD and PERIODSTODATE functions:

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

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

This is a common use...

You can do this with a combination of TAIL and FILTER. Here is an example of getting the latest sale date by department in the AdventureWorks cube:

SELECT

{[Measures].[Reseller Sales Amount]} ON...

Points 12-15 of the following page go through doing this:

http://www.databasejournal.com/features/mssql/article.php/10894_1497971_6/Introduction-to-SQL-Server-2000-Analysis-Services-Working-with-the-Cube-Editor.htm

maretix (9/30/2014)

---

Thanks for your answer...

Incredible i discover the same article too.

I am trying to understand...

So if i put attribute cause problem with PROPERTIES Attribute Hierarchy Enable = FALSE ...could be...

This error has to do with enabling/disabling attributes when there are linked items. Have a read of the following: http://martinmason.wordpress.com/2010/08/

venus.pvr (9/29/2014)

---

Hi,

If I have a cube with datasourceview definition queries selecting the complete data from the fact table, but my partitions set up only for current year and last year....

So you just need a count of the occupied rooms over the course of months, quarters and years?

I still don't think you need to distinctly count anything. Why not have...

Guitar_player (9/24/2014)

---

Hmm...As we have built everything in one Fact , we got this duplicate value issue and we cant go back at our current scenario and i have checked the...