Tag Info

New answers tagged

1

The way `PARALLELPERIOD' works is so that it moves up the hierarchy up to the specified level and then moves back or forward the number of periods, then moves down again using the same path. In this 'moving down the path' parallelperiod will descend the same member ordinal again. So if it moved up from the first member (in your example january) it will move ...


0

I think you are confusing things. First of all, processing the cube and processing the dimensions is sort of separate. I think you mean "processing the entire database". If you process only dimensions, and not the cube, the measures will never be updated. Also if you process dimensions, the cubes where the dimensions are linked will be in an "unprocessed" ...


0

Got it working: $ImpInfo=New-Object Microsoft.AnalysisServices.ImpersonationInfo $ImpInfo.ImpersonationMode = 'ImpersonateServiceAccount' $db.DataSourceImpersonationInfo = $ImpInfo $db.update() here a full working PowerShell (PS) example [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") $DBASserver = New-Object ...


0

You can combine multiple XMLA commands in a batch tag, try something like this: <Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" Transaction="true"> <Delete xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object> <DatabaseID>DB1</DatabaseID> </Object> ...


1

It's hard to give you a specific guidance on your best setup, but in any case there is no such thing as a trigger writing to an OLAP cube. I can give you some starting points though. You need to look into different storage options for your cubes. By default cubes use MOLAP (Multidimensional OLAP) in which you process a cube on a scheduled basis[1] and ...



Top 50 recent answers are included