Tag Info

New answers tagged


Depending on how much RAM is on your server, below is a good starting point (given you have SSAS ONLY running on the server) : click to enlarge: Refer to :SSAS Memory Configurations for Common Architectures and Analysis Services Memory Limits SSAS uses memory limit settings to determine how it allocates and manages its internal memory. ...


Ok, I finally did it! Without a complicated set, just creating a new dimension "DimOrdinal" with values 1-9999, It's connected to the Fact table with a new Ordinal column which contents a numerical value. That new column contents the datediff in days to the openingdate :D


So the calculated member I came up with is: sum( {ParallelPeriod([Calendar].[Fiscal Calendar].[Date],365,[Calendar].[Fiscal Calendar].CurrentMember):[Calendar].[Fiscal Calendar].CurrentMember}, [Measures].[Occurrences Received] ) simple enough, I guess. It could have been the ParallelPeriod for the Year level and 1 though I guess as this is a ...


this procedure runs XMLA statements in a SSAS server from a SQL Server. first we need to create the linked server to the SSAS. this you can see on the link below: How can I reduce OLEDB wait type in a SSAS linked server connection? After that I have done some changes on the procedure I have posted on the question. I will share the script here, so that it ...


Checking whether the dates are contiguous You don't say which DBMS you're using here, but you're using SSAS so I'm guessing SQL Server. If you're on a recent enough version, using LAG and LEAD in window functions can be really handy for this kind of task. You can order the rows by the start date or by an incremental ID if you have one, and then use these to ...


I found what the problem was. I had not deleted the database from its original location, after I detached it. I copied the database to the new drive, which on my case is T:. After I deleted the database from its original location, in my case F:\ssas\data, then I could attach the database from T:. After attached, I checked on the F:\ssas\data folder and ...


Check if KB3004375 windows update had installed recently and remove it. Then reboot the machine. Note: In case of core windows server installation stop the AppAssure Core Service to avoid dirty shutdown. (https://support.software.dell.com/appassure/kb/119400)

Top 50 recent answers are included