I am newbie to SSAS 2012 and here are my questions:
- Can we have measures of complex types (table)?
- Is it possible to order the results by a specific measure or attribute?
- My cube can be modeled as one dimensional hierarchy, is this generally good?
- Can I shard cubes using remote partitions on a range of members?
- Do we have remote table partitions with SQL Server 2012 databases?