Understanding SQL Dependencies View the Dependencies of a Table Related posts: Get to know an inherited SQL Server database How to document SSIS package control flow Documenting SSIS packages How to automate SSAS cube database documentation Automating SSIS packages documentation March 4, 2015 Cat...
SSAS is a Business Intelligence (BI) technology that Microsoft bought from Panorama Software in 1996. After the acquisition, the technology was upgraded and evolved and now it is part of the tools that come with SQL Server. This tool is an extremely powerful tool to create analytical reports f...
To create a custom DTS task Create a BAM Definition that requires an OLAP cube. For example use the Excel wizards, and leave one PivotTable® report as non-RTA view. Open the DTS package for cube processing that BAM creates. BAM creates one such package for each view, known as BAM_AN...
Check if the cube has processed “today” first & send a different email. Highlight the datetime if the refresh took longer than XX mins (assuming you know the start time) Create a new step with the following settings: Type: Transact-SQL script (T-SQL) Run As: SQL Server Agent Se...
See also this SQLFiddle By using grouping sets Another way to generate large tables is by using grouping sets, or more specifically by using the CUBE() function. This works much in a similar way as the previous example when self-joining a table with two record...
In Microsoft SQL Server Analysis Services, if you are working with an OLAP mining structure, you can slice the cube that the mining structure is based on. This lets you filter the data that is used to create the mining model. To slice a cube In Data Mining Designer in BI Development ...
A SQL Server query is suddenly running slowly, for no obvious reason. Grant Fritchey shares a 5-point plan to help you track down the cause and fix the problem.
I want to create a report based on Revenue range, for example revenue range is( 250- 350) then i have to list company count , state vise. I need sample query to do this. This is ...
MDX DDL– Data Definition Language statements are statements that allow you to define your cube structure. Things like defining measures, subcubes, calculations, etc. are all done using these commands: CREATE, DROP, ALTER, REFRESH and UPDATE MEMBER. ...
The user that you supply for this data source is important, as this account will be used to make the initial connection to Analysis Services. In this example, I’m going to use my GUYINACUBE\PBIConnector domain account. Analysis Service server admin ...