Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: olap
65 results found
Dump MDX OLAP Query output to a relational table from SSMS
I found two simple ways to dump MDX query output to a table and then dump the table data to excel file or text file as per need. The two methods are: 1. Using OPENROWSET Syntax : OPENROWSET('provider_name', 'datasource'; 'user_id'; 'password', {[ catalog.
Author:
artuladhar
Date: 5/16/2012 Section:
Blog
tags :
dump
,
file
,
MDX data
,
OLAP
,
output
,
query
,
Table
SSAS 2008 Storage Modes
In SQL Server Analysis Services 2008, we have three storage mode options available to us: Relational Online Analytical Processing (ROLAP), Multidimensional Online Analytical Processing (MOLAP) and Hybrid Online Analytical Processing (HOLAP). There are adv
Author:
DustinRyan
Date: 7/21/2010 Section:
Blog
tags :
HOLAP
,
MOLAP
,
ROLAP vs. MOLAP
,
SSAS 2008 Storage Modes
,
ROLAP
Near Real Time OLAP using SSAS Proactive Caching
If I had a nickel for every time I've heard from a business user that the OLAP solution must support current real time data from the source system, I'd have at least half a dollar. The fact is that in reality there is usually some acceptable degree of lat
Author:
MMilligan
Date: 1/13/2012 Section:
Blog
tags :
client initiated
,
partitioning
,
proactive caching
,
scheduled polling
,
sql server notification
OLAP PivotTable Extensions Update
OLAP PivotTable Extensions is a really cool free add-in for Excel that’s been around for quite a while now. It allows you to have some exposure to what’s going on under the covers (Among many other features) while you browse a cube using an Ex
Author:
DevinKnight
Date: 7/31/2012 Section:
Blog
tags :
Excel 2013
,
PivotTable
ssas Cube
Hi there. Well, there is a lot to consider before creating a cube, depending on your needs. I would ask you this: 1) Refresh frequency that data will be refreshed? daily, hour? 2) How many records will be updated in each refresh? 3) Is there any security
Author:
marcoadf
Date: 4/3/2012 Section:
Forum
tags :
Design
,
Security
ssas Cube
Hi there. Well, there is a lot to consider before creating a cube, depending on your needs. I would ask you this: 1) Refresh frequency that data will be refreshed? daily, hour? 2) How many records will be updated in each refresh? 3) Is there any security
Author:
marcoadf
Date: 4/3/2012 Section:
Forum
tags :
Design
,
Security
SQL Server “Denali”: Details on the next version of SSAS
At the recent TechEd North America 2011 conference, details on the next version of SQL Server called “Denali” were released. Part of those details were an update on the SQL Server Analysis Services ( SSAS ) roadmap. The main new feature in SSAS is a new d
Author:
jamserra
Date: 6/29/2011 Section:
Blog
tags :
Denali
,
SQL Server
,
SSAS
,
BISM
Microsoft Business Intelligence Firestarter - Full BI Project Life Cycle
Course Overview This one day seminar provides an end-to-end overview and direction for BI developers, administrators and managers who want to excel at leading high-performance teams and their organization through the Full BI Project Life Cycle (DW,ETL,OLA
Author:
Slava
Date: 2/23/2011 Section:
Blog
tags :
Dashboard
,
DW
,
SSAS
,
SSIS
,
SSRS
,
BI Training
SSAS Maestro–Redmond Day 2–Redux
Wow, what a day 2! This was our first day of lecture and it was a doozy. Stacia and I worked our way through advanced dimension concepts, partitioning and storage internals, processing tuning and EVEN ROLAP! Yes ROLAP! The class was great an asked so many
Author:
AdamJorgensen
Date: 6/14/2011 Section:
Blog
tags :
SSAS Maestro
,
Training
,
SSAS
Data warehouse vs. OLAP
Data warehouse ad OLAP terms are commonly used in the Business Intelligence world. Below are some points that differentiate them as per my understanding. Data Warehouse (DW) – Data warehouse is a term used in conjunction with data · Data from different da
Author:
indupriya
Date: 7/19/2010 Section:
Blog
tags :
Data warehouse
,
OLAP
Seven Steps to a Cube in Analysis Services 2008
In this article, Adam walks you through the basics of building a cube in SSAS 2008.
Author:
AdamJorgensen
Date: 11/24/2009 Section:
Article
tags :
Cube Design
,
SSAS 2008
,
SSAS Development
,
SSAS
SSAS error when processing the cube
Every couple of weeks I see this SSAS error when processing one of my cubes: Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element. An error occurred while parsing the ‘StorageMode’ element at line
Author:
jamserra
Date: 6/15/2011 Section:
Blog
tags :
SSAS
,
SQL Server
OLAP PivotTable Extensions
Wow, I am so excited that there is such a cool extension available for the excel 2007 onwards ,firstly I don’t know that we can use this cool features add-in extension within an excel .I have often used the PivotTable but I never try it for this particula
Author:
Anil
Date: 3/10/2011 Section:
Blog
tags :
Excel
,
MDx
,
PivotTable
,
SSAS
Visio Shapes for SQL 2012 - SSAS (OLAP & Tabular), Master Data Services, and Data Quality Services Servers
(Cross posted to http://markgstacey.net/category/office/visio/ ) I often use Visio diagams for architecture, and not having a shape for a SSAS server was always annoying. I'd built one out previously, but never took the time to polish it (which mostly mea
Author:
MarkGStacey
Date: 4/19/2012 Section:
Blog
tags :
SSAS DQS MDS OLAP Tabular Visio shapes stencils Analysis Services Data Quality Master visio stencil
MDX formatting
In my MDX formatting search I noticed that MS has put out a web service to format MDX code. http://blogs.msdn.com/b/business_intelligence_labs/archive/2011/09/13/format-mdx-amp-dax-web-service-for-formatting-is-available.aspx The OLAP PivotTable extension
Author:
rgtft
Date: 11/13/2012 Section:
Forum
Key Error processing SSAS cubes
Hi All, I am getting some error messages while processing the SSAS 2005 Cubes, the error messages are below: "Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fact_tableA, Column: dmd_Key1, Value: 0. " " Errors in the OLAP
Author:
am35
Date: 4/7/2011 Section:
Forum
Searching Dimension Properties from Excel
SQL Analysis Server Cubes allow for properties to be assigned to members. This is a noce feature but it doesn't seem to be exposed by many applications. Natively Excel is one of these apps, however by using the pivot tables extensions for excel addin this
Author:
MikeMollenhour
Date: 5/12/2010 Section:
Blog
tags :
Excel AS Description property
Reporting / visualization solutions for SSAS
What are some of the visualization tools / technologies that work well with SSAS and provide some or all of the following features: 1. Ability to Connec / Query OLAP cubes 2. SharePoint integration 3. Silverlight support 4. High quality / interactive char
Author:
atresso
Date: 4/18/2011 Section:
Forum
tags :
reporting services
,
silverlight
,
visualization
SSAS best resources
Here are the SSAS sites I have bookmarked. http://www.ssas-info.com/ They do a good job of searching all bloggers and bringing the best SSAS articles and blogs to one site. http://www.mosha.com/msolap/mdx.htm One of the inventors of MDX site. http://www.m
Author:
DevinKnight
Date: 12/24/2009 Section:
Forum
Slow Cube Build Times
I have a production Cube Sql 2008 R2 SP1 that takes about 1 hr and 45 minutes to each day. I ran a trace on the build process to see where the time is really being chewed up. The two largest resource processes in the build are the degenerate dimension a
Author:
fsugeiger
Date: 12/6/2011 Section:
Forum
tags :
Cubes
Can we create Dynamic Partition in Cube using AMO and ADOMD.net?
I believe code inside SSIS script Task can be used in .net application. Althought, never tried. I have my AMO in vb.net, not in c#. About stored procedures, there are a couple SPs for this purpose. Take a look: http://weblogs.sqlteam.com/jeffs/archive/200
Author:
marcoadf
Date: 1/24/2011 Section:
Forum
SSAS – Deployment Wizard
The Analysis Services Deployment Wizard is an often under utilized but important tool when moving your OLAP database throughout your environment. Often I see developers deploy directly from BIDS to all Development, QA, and Production environment by changi
Author:
DevinKnight
Date: 10/26/2011 Section:
Blog
tags :
SSAS Tutorial
Calculated Member to sum YTD has stopped working but sum "All time to Date" is still fine.
I have discovered the problem. I have added a Fact Dimension (Degenerate Dimension) so that I could drill down to my GL Entries. I had it set to ROLAP rather than MOLAP Removing this Dimension allows the YTD calcuations to function correctly. Anyone have
Author:
robbie
Date: 5/20/2010 Section:
Forum
SQL Server “Denali”: New Certifications
According to the post SQL Server “Denali” Experts–We Need You! that asks for your feedback on the Microsoft certifications for the next version of SQL Server, there will be seven exams: Four certification exams are planned for SQL Server “Denali” Business
Author:
jamserra
Date: 7/27/2011 Section:
Blog
tags :
SQL Server
,
Denali
OpenRowSet with variables as parameters
Recently I've had to write a generic stored procedure to query a DMV using OPENROWSET. much to my chargrin I discovered that OPENROWSET will not take variables as its parameters, so what i initially thought would be a trivial matter turned into a 2 hour b
Author:
Maxui
Date: 1/12/2012 Section:
Blog
tags :
OpenrowSet
Page 1 of 3 (65 items)
<< Prev
1
2
3
Next >>
Go to page:
[Go]