Paul Burton

MDX Calculations Across Multiple Calendars Using Nested SCOPEs

A solution to the problem of multiple calendar calculations within SSAS Multimdimensional cubes using nested SCOPEs

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2016-10-10

2,935 reads

“Don’t aim to have others like you; aim to have them respect you.” –...

If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...

Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...

Comments posted to this topic are about the item SQL Art, Part 4: Happy...

WA:08218154393 Jl. Dr. Saharjo No.149 G-H, RT.5/RW.4, Manggarai Sel., Kec. Tebet, Kota Jakarta Selatan,...

WA:08218154393 Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete Sel., Kec. Cilandak, Kota Jakarta...

In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:

UserID  UserPermissions
15
23
37

What is returned when I run this code:

select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 3;