Ok, I may be wrong but it seems like you need to do either one of two things:

1) If you have duplicates in your fact table, eliminate them. You can...

Guitar_player (9/24/2014)

---

Thank you 🙂 !! I will try this in my freetime ...Now i need another help .I am trying to find the Distinct count of Measure and so i...

Guitar_player (9/24/2014)

---

Hi PB_BI,

some what i was able to solve the problem..with other technique...i have defined a new column and assigned the value as 1 to it and...

Right...this is a bit of cludge but it performs ok and does the trick. This uses the AdventureWorks fiscal hierarchy so it is counting the 5th level (which is day)....

Ok, to get a basic count of days in each member you can use a calculation like this:

MEMBER DayCount AS

COUNT(Descendants([i]your dimension name[/i].[i]your hierarchy name[/i].CurrentMember,4),INCLUDEEMPTY)

What that is doing is counting...

You asked the same question, and it was answered, a few days ago http://www.sqlservercentral.com/Forums/Topic1612945-17-1.aspx

Then it isn't possible in DMX alone. You would have to build something with the precedence constraints within SSIS to get around the task returning no rows.

Shadab Shah (9/22/2014)

---

Hi PB_BI,

Thanks for the reply, but i am using the following query,

SELECT top 1 lock_object_id

FROM $System.DISCOVER_LOCKS

WHERE Lock_type = 4

I googled but i found out that i cannot use,...

In that case you'll want to look at implimenting a Many-To-Many solution. Read the article that I linked to, that will give you a good grounding on the concepts and...

vineet_dubey1975 (9/22/2014)

---

Hi All,

I have below tables :

Employee ( ID, EmployeeCode,fname,lname)

Project(ID,ProjectCode,ProjectName)

ProjectTeam(ID,Employeecode,ProjectCode,StartDate,EndDate)

How do I design fact and dim table for the analysis of the data (Year->Quater->Month->Day)

A) TotalEmployee count, ...

From what I can tell, you would just take the max of your first measure over your dimension members and the max of your 2nd member over your dimension members...

SSAS is really meant for higher-level, aggregated type of work. There are a couple of ways to get to these "lists" and each have their pros and cons....

1) You could...

It depends what type of value you are looking to return but you could do an IIF(IsEmpty( construct in a member.

So for example in adventure works I could say:

WITH...

Out of the box, SSAS will always put a Distinct Count in it's own measure group. There are, however, other methods that you can try which may or may not...

I'm not sure what you're trying to achieve with this query (ParallelPeriod is usually used in conjunction with an aggregation to give a value) but if you just need the...