You can connect a fact table to as many dimension tables as you like. There's no technical limit on that.

You just have to make sure that it make sense to...

I don't think there is a hard-coded limit.

But if your number of dimensions is going over 30, you might want to investigate of some dimensions can't be combined.

Regarding facts: if...

That should be possible yes:

Hiding parameter area when viewing reports

In that case I would write my own parameter selection boxes and call the report using an URL with the parameters supplied.

It didn't bother me.

It could bother me if...

It would be much easier to write a query to answer your problem (and test it) if you would provide table DDL and sample data.

See the first link in my...

Grant Fritchey (3/6/2014)

---

It's not about what the 'sa' account has access to. It's about what the account that SQL Server is running under has access to. That account determines what...

SELECT ID, Code, StudentName, Age, Term, NumberOfSubject

FROM

(

SELECT ID, Code, StudentName, Age, Term, NumberOfSubject, RID = ROW_NUMBER() OVER (PARTITION BY Code ORDER BY ID)

...

Please do not crosspost. It wastes peoples time and fragments replies.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1548128-8-1.aspx

This can easily be achieved by using NTILE.

DECLARE @parts INT = 5;

SELECT

StartDate= MIN([Date])

,EndDate= MAX([Date])

FROM

(

SELECT

[Date]

,Parts = NTILE(@parts) OVER (ORDER BY [DateOfYear])

FROM [dbo].[myDateTable]

WHERE [Year] = 2014

) tmp

GROUP BY Parts;

MysteryJimbo (3/6/2014)

---

Koen Verbeeck (3/5/2014)

Pfff, than you have never been in Belgium before 😀

If we wouldn't be having the most traffic jam congested cities in the world, you could drive through...

These are some serious rounding errors and it will not be easy to solve them.

You can add extra precision, but what if you divide 100 by 3? Even float won't...

Please do not crosspost. It wastes peoples time and fragments replies.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1548135-1550-1.aspx

paul.knibbs (3/6/2014)

---

MysteryJimbo (3/6/2014)

Great Britain (UK minus Northern Ireland) itself is about 8 hours east to west and about 16 hours north to south depending on your location and traffic. ...

If I'm not mistaken sa is a SQL Server account, meaning it does not map to a domain/local user which you can give permissions on resources.