The below SQL will in a database on a Microsoft SQL-server find all tables with information about the tables schema, name, creation date and modifications date.
schema_name(t.schema_id) as schema_name
, t.name as table_name
from sys.tables t
order by table_name
If you get the error below when processing a cube in SSAS. You might have partitions in the cube, that doesn’t have corresponding data in the underlying relational tables.
Errors in the OLAP storage engine: The restrictions imposed on partition slice where violated.
A solution could be to just delete the affected partitions from the cube.
Great tutorial for setting up a Microsoft BI environment with Microsoft Sharepoint 2013 and Microsoft SQL-server 2012 Enterprise Edition. A lot of the BI features in the Microsoft platform requires an Enterprise Edition of Microsoft SQL-Server 2012.
I have also made a PDF of the tutorial.