|
| Portfolio Slicer - free BI application to track your investments in Excel with PowerPivot | 2012-May-31 | 937 |
| Video - SSAS database folder structure | 2012-Jan-29 | 1158 |
| Script to backup SSAS database and delete old backup files (using ascmd.exe) | 2011-Feb-10 | 3313 |
| Q: How to setup SSAS anonymous authentication - to access data from internet or another domain? | 2011-Feb-01 | 3360 |
| Excel slicer impact on query performance | 2010-Nov-25 | 2349 |
| Q: Why on SSAS 2005 after restoring database backup I am getting corruption error? | 2010-Sep-23 | 1438 |
| Q: When I am browsing Real-time ROLAP cube, I am getting error message: OLE DB Error: OLE DB or ODBC error: You do not have permission to run 'SP_TRACE_CREATE'.; 42000. | 2010-Mar-13 | 2740 |
| Q: I have measure in my cube that shows duration on some event in seconds. How can I convert numeric result to string in the format hh:mm:ss? | 2010-Mar-10 | 4718 |
| Q: How in MDX can I override formating for all calculated measures in one measure group? | 2009-Dec-03 | 3881 |
| SSAS error during deployment - "The connection either timed out or was lost" | 2009-Oct-06 | 2923 |
| Script to automate SSAS partition management (SQL + SSIS) | 2009-Jul-03 | 21479 |
| Q: In SSAS 2008 I am getting an error message when generating usage based aggregations: "Internal error: The parameter is not valid." | 2009-Jun-08 | 2557 |
| Q: How can I create a new Analysis Services project from existing SSAS database? | 2009-May-26 | 2952 |
| Q: How can I identify version/build of Microsoft SSAS 2005/2008 on my server? | 2009-May-05 | 3454 |
| Analysis Services 2008 $SYSTEM.DBSCHEMA_% DMVs | 2009-Jan-26 | 2385 |
| Analysis Services 2008 $SYSTEM.DMSCHEMA_% DMVs | 2009-Jan-26 | 2042 |
| Analysis Services 2008 $SYSTEM.MDSCHEMA_% DMVs | 2009-Jan-26 | 7530 |
| Q:How do you map MEASURE_AGGREGATOR field int value in the MDSCHEMA_MEASURES DMV to text representation? | 2009-Jan-26 | 3165 |
| Speeding up the Query Parameters Dialog in the SSRS Query Designer | 2009-Jan-22 | 2807 |
| Q: How can I get a list of measures in one measure group from SSAS DMVs? | 2009-Jan-21 | 3263 |
| Q: How in DMV can I convert data_type field from integer to string representation? | 2009-Jan-20 | 2973 |
| Q: How can I get a list of available SSAS databases using DMVs? | 2009-Jan-20 | 2320 |
| Q:I would like to create an e-mail alert when some criteria has been met after processing Analysis Service cube. Any sugestion? | 2009-Jan-06 | 2358 |
| Q: Which string functions can be used in the queries on SSAS DMVs? | 2008-Dec-08 | 2729 |
| Q: How in SSAS 2008 can I get the list of available MDX functions from DMVs? | 2008-Dec-04 | 3558 |
| Q: How and where do I run queries on SSAS 2008 DMVs (schema rowsets)? | 2008-Dec-03 | 2718 |
| Q: How to fix error "Error loading metadata: Parser: The end of the input was reached." | 2008-Dec-02 | 4848 |
| Q: How can I start Analysis Services service from the command line? | 2008-Nov-26 | 4521 |
| PowerShell script to process all dimensions and cubes in one DB limiting workload | 2008-Nov-26 | 9912 |
| PowerShell script to process all dimensions in one Analysis Services database | 2008-Nov-09 | 5482 |
| Powershell script to list info about one Analysis Services database | 2008-Nov-09 | 5364 |
| PowerShell script to list info about SSAS databases | 2008-Nov-03 | 4881 |
| How to setup your computer to run PowerShell with SSAS | 2008-Nov-03 | 4833 |
| Q: Can I migrate Analysis Service 2000 database to Analysis Services 2008? | 2008-Nov-03 | 3774 |
| How to use MDW to collect Analysis Services 2008 performance counters | 2008-Sep-18 | 3299 |
| Analysis Services 2008 performance counters | 2008-Sep-13 | 10992 |
| WSH script to get SSAS DB info about aggregation designs | 2008-Jul-11 | 4241 |
| SSIS Package to drop and create partitions based on data in SQL Server table | 2008-Jul-04 | 7093 |
| Analysis Services 2008 $SYSTEM.DISCOVER_% DMVs | 2008-Jun-23 | 4166 |
| Microsoft SQL Server 2008 RC0 - New Adventure Works Sample Databases for SSAS | 2008-Jun-11 | 5550 |
| SSAS 2008 RC0 - New function SYSTEMRESTRICTSCHEMA for restricted schema rowsets - DMVs | 2008-Jun-07 | 2615 |
| Excel 2007 Pivot Table with SharePoint On Vista PC - works good after SP1 | 2008-Jun-07 | 2973 |
| How to fix dimension processing error 'mdprocessdim.cpp line 3429 function MDProcessPropertyJob' | 2008-May-09 | 4597 |
| In an MDX query how can I get the top 3 sales years based on the order quantity? | 2008-Apr-04 | 10858 |
| How in the report can I order date dimension members in descending order? | 2008-Apr-04 | 7719 |
| Analysis Services 2005 and 2008 with PowerShell - it works | 2008-Mar-27 | 1616 |
| SSAS 2008 CTP6 - new DMV $SYSTEM.DISCOVER_OBJECT_ACTIVITY | 2008-Mar-18 | 2413 |
| SSAS 2008 Katmai Change Summary - What is new | 2008-Feb-26 | 9074 |
| SQL Server 2008 February CTP6 - Read-only SSAS Shared Scale-out and other changes | 2008-Feb-20 | 1516 |
| Designing Analysis Services database for Inventory type applications | 2008-Feb-18 | 4472 |
| How to find slice values that Analysis Services assigned to the partition dimensions? | 2008-Feb-04 | 7591 |
| MDX-When I process cube, I can see that data is loaded, but when I query data, all measures are empty | 2007-Dec-06 | 6533 |
| Why domain user group name is not found when creating Analysis Services security role | 2007-Dec-06 | 5325 |
| When accessing calculation tab in BIDS I am getting error Unexpected error occurred | 2007-Dec-05 | 8314 |
| How to fix Analysis Services deployment error No mapping between account names and security IDs was done | 2007-Dec-05 | 19876 |
| WSH Scripting for Analysis Services 2005 | 2007-Dec-03 | 1830 |
| Customizing object names in Analysis Services database using translations | 2007-Dec-03 | 2385 |
| Katmai Analysis Services 2008 November CTP5 - tests on metadata rowsets | 2007-Nov-30 | 1317 |
| MS SQL Server Analysis Services 2008 - November CTP quick review | 2007-Nov-30 | 792 |
| How to use parameters with SSRS 2005 against a 2000 Analysis services Cube | 2007-Sep-27 | 3972 |
| How do you test Analysis Services 2005 role settings impact on browsing / querying behavior? | 2007-Sep-11 | 6940 |
| How do you set Analysis Services 2005 drillthrough security on the cube? | 2007-Sep-11 | 7046 |
| MDX-How can I change currency symbol based on selected currency dimension member | 2007-Sep-06 | 14977 |
| How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and project | 2007-Sep-05 | 85231 |
| SSAS 2008 Katmai - MDX Changes | 2007-Aug-26 | 6246 |
| SSAS 2008 Katmai - info from August 9th webcast | 2007-Aug-12 | 888 |
| SSAS 2008 Katmai - upcoming changes in the next CTP | 2007-Aug-01 | 649 |
| SSIS package to backup all Analysis Services databases on one instance | 2007-Jul-17 | 9799 |
| I cannot start Analysis Services 2005 SP2 on Vista PC. Error - The service cannot be started... | 2007-Jun-25 | 8274 |
| SSAS 2008 June Katmai - more testing results | 2007-Jun-18 | 568 |
| How do I move Analysis Services 2005/2008 databases to a different folder | 2007-Jun-18 | 10071 |
| How can I hide dimension attributes/hierarchy in one cube, but leave them visible in other | 2007-Jun-13 | 11448 |
| SSAS 2008 - Info from chat session | 2007-Jun-12 | 595 |
| SSAS 2008 Katmai review - installation and first impressions (by Vidas Matelis) | 2007-Jun-12 | 664 |
| MDX-How do I calculate sales for 12 Month to date? | 2007-Jun-08 | 21909 |
| SSIS Package to process all dimensions in one SSAS Database | 2007-Jun-06 | 7985 |
| When processing SSAS cube I am getting error "Errors in the OLAP storage engine" or "Internal Error". | 2007-Jun-05 | 21486 |
| Why In Reporting Services MDX query disappears after leaving "Data" tab. | 2007-Jun-05 | 5433 |
| How do you generate Report Model for Reporting Services Report Builder based on SSAS database | 2007-Jun-04 | 15725 |
| Analysis Services 2005 error: Errors in the metadata manager. The attribute with ID of ., Name of . refer | 2007-May-28 | 18932 |
| How can I get a list of cubes in one Analysis Services 2005 database using XMLA? | 2007-May-22 | 5002 |
| How can I get a list of Analysis Services databases on the server using XMLA? | 2007-May-22 | 5394 |
| SSIS package to process all dimensions in SSAS 2005 DB | 2007-May-19 | 1078 |
| SSIS package that process all partitions/measure groups/cubes in one database | 2007-May-19 | 1635 |
| Learning SQL Server Analysis Services 2005 and MDX - resources online | 2007-May-16 | 12502 |
| MDX-How do I clear Analysis Services (SSAS) database cache? | 2007-May-15 | 19486 |
| SQL Server Analysis Services 2005: Time Intelligence solutions on the web | 2007-May-14 | 4140 |
| In Excel 2007 Analysis Services 2005 Pivot Table Field list is empty | 2007-May-08 | 4601 |
| MDX-How do you format or round KPI expression value? | 2007-May-07 | 21432 |
| Analysis Services 2005 XMLA script to add/drop existing partition aggregate | 2007-May-07 | 11100 |
| How do you create distinct count measure in the separate measure group from the same fact table | 2007-May-04 | 10404 |
| MDX-How to create calculated member for AVG sales over last 3 years based on NOW()? | 2007-May-03 | 14175 |
| MDX-How can I get Last (Previous) Year to Date (YTD) values? | 2007-May-01 | 35953 |
| MDX query to get sales by prod line for period plus number of months with NON EMPTY sales? | 2007-Apr-30 | 7582 |
| MDX-How Can I define SCOPE in MDX for all measures in multiple measuregroups? | 2007-Apr-30 | 9135 |
| How can I prevent client submitting MDX queries to the Analysis Server 2005 that run too long | 2007-Apr-29 | 3174 |
| How can I create a script that generates XMLA script from Analysis Services solution project | 2007-Apr-28 | 13067 |
| How can I build XMLA script from Analysis Services Solution project interactively-BIDS | 2007-Apr-28 | 6766 |
| Analysis Services 2000 and 2005 Connection string properties | 2007-Apr-28 | 45241 |
| What are Analysis Services 2000/2005 connection string properties | 2007-Apr-26 | 5559 |
| During processing I can see that SSAS read x records, but all measures in the cube return 0 | 2007-Apr-25 | 3895 |
| Excel SSAS Pivot Table warning "Security Warning Data connections have been disabled" | 2007-Apr-25 | 10662 |
| Excel with SSAS Pivot Table "Excel found unreadable content in" | 2007-Apr-25 | 9348 |
| MDX-How do you write query that returns measure ratio to parent value? | 2007-Apr-24 | 12089 |
| Is there a way to split Analysis Services 2005 database between different disks | 2007-Apr-24 | 3060 |
| How do you change Analysis Services 2005 measure group ID property value | 2007-Apr-24 | 3705 |
| How can I build MDX statement as a string and pass it into Reporting Services? | 2007-Apr-23 | 5373 |
| How do you make Pivot table to show calculated members from Analysis Services 2005 | 2007-Apr-23 | 4717 |
| How do you increase timeout for queries executed during Analysis Services cube processing | 2007-Apr-23 | 6741 |
| How in SSAS 2005 do you create what is used to be "Member Properties" in Analysis Services 2000 | 2007-Apr-22 | 9860 |
| How in Analysis Services do you order dimension attribute during design | 2007-Apr-21 | 19145 |
| How do you setup dynamic security to SSAS 2005 database based on current user | 2007-Apr-19 | 7521 |
| Experiencing delay when connecting to SSAS using SQL Server Management Studio? | 2007-Apr-18 | 3020 |
| MDX-Why YDT function sometimes return incorrect results for measure with NON_EMPTY_BEHAVIOR? | 2007-Apr-17 | 6145 |
| How to use AMO in VB.NET code to process cubes/partitions | 2007-Apr-17 | 7941 |
| MDX-Why simple calculated measure works much slower than real measure. | 2007-Apr-17 | 6867 |
| MDX-I would like to create calculated measure that instead of summing children amounts,uses last child | 2007-Apr-17 | 12413 |
| MDX-How do you write query that uses execution date/time (NOW()) as a parameter? | 2007-Apr-15 | 14040 |
| MDX-How do you calculate monthly average of one year, optionally including empty months? | 2007-Apr-14 | 23199 |
| MDX-How can I compare members from different dimensions that have the same key values? | 2007-Apr-14 | 9884 |
| What TCP port SQL Server Analysis Services 2005 uses | 2007-Apr-14 | 25503 |
| Can you specify bucket start/end values for groupping attributes using DiscretizationMethod | 2007-Apr-14 | 5443 |
| Can you apply security on Analysis Services cube partitions | 2007-Apr-14 | 4117 |
| What are recommended values for the InstanceSelection property in Analysis Services | 2007-Apr-08 | 6638 |
| When in Analysis Services should I consider splitting measure group into partitions | 2007-Apr-08 | 3553 |
| MDX-How do you make calculated measure to be default cube measure | 2007-Apr-08 | 7954 |
| MDX-How can I setup default dimension member in cube calculation script? | 2007-Apr-08 | 11797 |
| MDX-How Can I define SCOPE statement for all but one measures in one measure group | 2007-Apr-07 | 9244 |
| MDX-How Can I define SCOPE statement for all measures in one measuregroup | 2007-Apr-07 | 5215 |
| MDX-Query to get count of months with sales amount > 0 in defined period | 2007-Apr-05 | 9035 |
| MDX-Query to get sales by product line for specific period plus number of months with sales | 2007-Apr-05 | 6307 |
| MDX-Query example that returns list of months from start of year up to specified month | 2007-Apr-03 | 9425 |
| MDX-Query to get latest months and previous years same months data | 2007-Apr-03 | 11002 |
| After processing SSAS cube I get error: Server error : Process error [object doesn't exist] | 2007-Apr-02 | 3432 |
| MDX-How to execute query from SQL Server | 2007-Apr-02 | 10045 |
| After processing dimension some of the attribute members are missing even I know they were read | 2007-Mar-30 | 4194 |
| MDX-Query to show year level data for all years except last one, and month level data for last year | 2007-Mar-29 | 7510 |
| Example how to generate SSAS measure group aggregations in SSIS package | 2007-Mar-29 | 4311 |
| MDX-Query to show the first day of the last date month in the cube | 2007-Mar-29 | 8689 |
| MDX-Query to get the first month of the last year loaded into a cube | 2007-Mar-29 | 5256 |
| MDX-query to get the last Month loaded into a cube | 2007-Mar-29 | 7334 |
| MDX-Query to show totals of a set with just some members | 2007-Mar-29 | 5020 |
| How do you design KPI goal that is dimension dependant | 2007-Mar-29 | 6544 |
| I created Date/Time dimension, but Month level members are ordered alpabetically. | 2007-Mar-28 | 7335 |
| MDX-How to use the Filter function in a SCOPE statement | 2007-Mar-28 | 13307 |
| MDX-How to create a SCOPE statement based on the Member property | 2007-Mar-28 | 8143 |
| MDX-How do you specify SCOPE For Dimension to include all members before certain member | 2007-Mar-28 | 6358 |
| MDX-How do you specify SCOPE For Dimension to include all members after certain member | 2007-Mar-28 | 6822 |
| MDX-How can I use dimension members/measures in query when sometimes they might not exists | 2007-Mar-28 | 7960 |
| MDX-How do you compare dimension level name to specific value | 2007-Mar-27 | 10050 |
| MDX-How do you get Last month in the time dimension | 2007-Mar-27 | 9818 |
| MDX-How do you extract first tuple from the set? | 2007-Mar-27 | 9559 |
| MDX-How do you extract first member from the tuple? | 2007-Mar-27 | 8094 |
