Stack Overflow
Stack Overflow

Questions tagged [olap-cube]

An OLAP cube is a multidimensional database that is optimized for data warehouse and online analytical processing (OLAP) applications.

An OLAP cube is a multidimensional database that is optimized for data warehouse and online analytical processing (OLAP) applications.

An OLAP cube is a method of storing data in a multidimensional form, generally for reporting purposes. In OLAP cubes, data (measures) are categorized by dimensions. OLAP cubes are often pre-summarized across dimensions to drastically improve query time over relational databases. The query language used to interact and perform tasks with OLAP cubes is multidimensional expressions (MDX). The MDX language was originally developed by Microsoft in the late 1990s, and has been adopted by many other vendors of multidimensional databases.

820 questions
0
votes
2 answers

How to create offline OLAP cube in C#?

I have a problem with creating an offline OLAP cube from C# using following code: using (var connection = new OleDbConnection()) { connection.ConnectionString = "Provider=MSOLAP; Initial Catalog=[OCWCube]; Data…
jimmyjoe
0
votes
1 answer

Processing performance hit in SSAS with 2000+ partitions in 2008 R2

I am looking into the performance hits in processing time when increasing the number of partitions in a cube. I realise from http://technet.microsoft.com/en-us/library/ms365363.aspx that in theory it can be 2+ billion however I expect there is still…
Sara
  • 612
  • 5
  • 21
0
votes
1 answer

ORA-00972 error from dbms_cube.import_xml() call

I create a cube by hand in AWM, and export it as a template. But when I try to import it with dbms_cube.import_xml('/app/oracle/product/11.2.0/XML_DIR','test.xml'), it throws an ORA-00972 error. ORA-00972: ORA-06512: "SYS.DBMS_LOB", line…
Sun Fuqiang
  • 21
  • 4
0
votes
1 answer

MDX Help: - Comparing Values in Two Max Time Periods within a larger Set of Time Periods to Populate an Indicator

I'm brand new to MDX and need some help. In SSRS I have a dataset that pulls from an SSAS cube. The dataset always contains six months of data. What I need to be able to do is to compare a value for the max(timeID) with a value for the second…
JCB
  • 3
  • 4
0
votes
1 answer

OLAP Cube: per Business Process? per Fact table?

So i've finished my dimensional modeling, it resulted in 2 business process, 1 simple with only one fact table and a few dimension, the other one a bit more complex with 2 fact tables (related in a similar way has Invoice and InvoiceRecord) and a…
RASMiranda
  • 371
  • 6
  • 19
0
votes
1 answer

Mutually exclusive facts. Should I create a new dimention in this case?

There is a star schema that contains 3 dimensions (Distributor, Brand, SaleDate) and a fact table with two fact columns: SalesAmountB measured in boxes as the integer type and SalesAmountH measured in hectolitres as the numeric type. The end user…
mishau
  • 582
  • 4
  • 11
0
votes
1 answer

How to show last value of a column in MS Analysis Service?

I have a cube with several dimensions. I need (a measure, calculation, whatever...) to show last value of a column, assuming the table is sorted by another column. Something like: SELECT TOP 1 column_1 FROM table_1 WHERE «The user's selected…
renegm
  • 610
  • 2
  • 5
  • 12
0
votes
2 answers

what-if analysis on Rolap Or Molap & how?

i would like to simulate what-if analysis on a OLAP cube For example, i would like to know the impact on departmental resource budgets by moving employees between departments or the movement in cost of manufacture if a product is moved from one…
Chikawi
  • 1
  • 4
0
votes
1 answer

MDX, calculated member with olap cube

I have a question related to cubes with Microsoft Technologies, we have an SSAS Cube built on BIDS 2008 version, and the requirement is to group (sum) the measure quantity taking the previous twelve months and excluding some values in one dimension.…
Gilberto Gutiérrez
  • 61
  • 1
  • 9
0
votes
1 answer

Cube Processing Error - CREATE DATABASE permission denied in database 'master'.; 42000

These are the errors (repeated a few times) I get when processing a cube in SQL Server 2008 (on Windows 8 x64 on VMWare). OLE DB error: OLE DB or ODBC error: Cannot attach the file '\\vmware-host\Shared…
Michael Johnston
  • 2,364
  • 2
  • 27
  • 48
0
votes
1 answer

Design OLAP cube and MDX query for my needs

I have an OLAP cube with a time dimension [year > month > day month > hour]. Now I need to create some reports very fast such as report for all sales of yesterday (like: 07:00 AM - 265 sales), all sales for last month (like: 1st February 2013 -…
Eli_Rozen
  • 1,301
  • 4
  • 20
  • 31
0
votes
2 answers

Member with Named set returns always the same value in SSAS

I'm needing to query a cube as a plain table. Also, i need to use a named set for performance reasons (the query takes 10x if not using the set). The issue is that i'm getting the same value for every row for the Date Time calculated member. BTW,…
nnimis
  • 464
  • 9
  • 17
0
votes
1 answer

Mondrian doing sub-select on group by oracle

When I do this dimension:                
Michel Miola
  • 3
  • 2
  • 5
0
votes
2 answers

MDX adding together two cube measures across two role playing dimensions

I have two queries which I would like to join together,which would give me the calculated total of the row. The problem I have is that although the measures are from 1 fact table the Squad names are in two role playing dimensions. I'm extremely new…
user1969857
  • 3
  • 2
0
votes
2 answers

SSRS: How to select two or more values from a long filtered multiple selection list with different search strings

Let's consider a multiple selection parameter on a report: Employee This parameter has a lot of possible values. Initially nothing is shown on the list and there is a textfield search parameter associated, that updates the Employee selection list…
KLaine
  • 43
  • 5
1 2 3
…
54 55