We have a requirement in our database to represent various "temporal" relationships in our data. A simple example would be an event table where I want to know how many days prior to the event date ...
I am looking for the right approach how to implement group/member like relationship in the cube dimension. i have attached the smaller version of my tables currently I have. Table-1 is SecurityTable, ...
I have a SSAS Cube with 35 dimensions and 10 measures. Some of the dimensions are quite large in size. In almost all dimensions data either get updated and inserted. Measures have high volume of ...
Possible Duplicate: Real Time SQL Server Analysis Services Cube Processing Report I would like to know if there is a way to generate a report to determine which SQL Server Analysis Services ...
Apparently this feature was available in previous versions but has now been removed. What are some alternatives?
I'm new to using SQL Server 2008 R2 SSAS. I have the following tables in my database, that I wish to model using SQL Server Analysis Services: Table1 ServiceTypeID | ServiceTypeName ...
I have an issue that i face every time i decide to build a cube, and i haven't found a way to over come it yet. the issue is how to allow the user to define Range of things automatically without ...