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
1 answer

How do I display subtotals in cube browser in SSAS 2012 (Sql Server Data Tools)?

Apparently this feature was available in previous versions but has now been removed. What are some alternatives?
Sarah
  • 133
  • 1
  • 2
  • 7
0
votes
1 answer

My calculated member is not working

I tried to create a calculated member for displaying profit for each product, but I got an error on the "select". Can anyone help me out with this since I am newbie in this? CALCULATE; CREATE MEMBER CURRENTCUBE.[Measures].Profit_Per_Produkt AS…
Palmer
  • 493
  • 4
  • 13
0
votes
2 answers

Excel VBA: PivotTable CubeField Fact Table Name?

I'm working with a large OLAP Cube, and I'm building very rudimentary search functionality to help me parse through the amount of data (~30 fact tables, 30 dimensions, plus calculated measures), but I've come across an interesting issue. When I…
Kevin Pope
  • 2,964
  • 5
  • 32
  • 47
0
votes
1 answer

Full Process cube in SSIS

I have a XMLA script like below to process (full process) the cube Adventure Works DW Standard Edition Adventure Works DW ProcessFull …
Zerotoinfinity
  • 6,290
  • 32
  • 130
  • 206
0
votes
1 answer

SSAS dimension member grouping

I am new to SSAS and i have a problem with the dimension members for which i haven't been able to find a solution. Is it possible to group dimension members like: Member 1 Member 2_1 Member 2_2 Member 2_3 Member 3 ... so that the user browsing the…
maxPayne
  • 35
  • 1
  • 6
0
votes
2 answers

Pentaho Mondrian - Olap drilldown in java program

I'm using Mondrian 3.4 as the Olap Server to my application written in Java. Currently i wanted to perform some typical Olap operations in a cube, but i could't find any pointers that guided me to how to perform a drilldown operation in a cube with…
Paulo Rodrigues
  • 593
  • 14
  • 32
0
votes
1 answer

Rename Catalog and Cube name in Analyzer

I have one query regarding pentaho cube: Lets assume a cube (say sample ) with schema name as schema1 and cube name as cube1. I renamed that schema and cube to schema2 and cube 2 respectively and published on schema workbench. As my analyzer was…
ShikhaT
  • 71
  • 7
0
votes
1 answer

trying to explore olap cube for ms sql but have a product file for multiple branches that may have the same key across all branches any ideas?

i need to create a cube based on sales for multiple branches but im not sure how to approach the fact that each branch may use the same product code. in vs 2008 it wont process the cube because it sees that this code is duplicated in my master…
JazziJeff
  • 721
  • 4
  • 17
  • 35
0
votes
1 answer

Unable to build SQL Server OLAP Cube when there is no rows corresponding to foreign key in a table

I am new to SQL Server OLAP Cubes. I am having the following issue like ex I have purchase order and invoice tables which are used in data source view. These two tables are related by purchase order ID which have one to many relationship…
Grasshopper
  • 1,778
  • 6
  • 27
  • 48
0
votes
1 answer

Can C# APIs act as datasource?

I have a need for Multidimensional cube to fetch data from some C# APIs instead of a database. So I have 2 questions: How to create such APIs. For this, what type of project i need to create in visual studio 2010? And what all APIs do I need to…
monish001
  • 671
  • 2
  • 8
  • 20
0
votes
1 answer

Running MDX query on Mondrian Cube in PHP using olap4php

I am using olap4php to connect to the Mondrian's default FoodMart XML schema and I need to run an MDX query on it to see whether I can get it to work. My current code is as below :- require_once( 'olap4php/autoload.php' ); use…
ilight
  • 1,622
  • 2
  • 22
  • 44
0
votes
1 answer

Create Analysis Services project in 2012, deploy to 2005-2012. Compatibility?

I would like to create Analysis Services project (data cube) in Visual Studio 2010 which is in SQL Server 2012 but need to be able to deploy my cubes to older SQL servers. (2005 and newer) Is this supported scenario? I found on MS sites that there…
Chatumbabub
  • 1,557
  • 2
  • 18
  • 30
0
votes
1 answer

MDX object not found in cube

I have districts with areas. and i'm trying to fetch data from my cube. the problem is: i add new area to district in database. the data in cube is recalculated only once a day. so rigth after i have added new area it will be not present in my…
user1178399
  • 1,028
  • 8
  • 17
  • 32
0
votes
1 answer

iReport : How to design report from OLAP cube with multiple dimension and calculated measure in iReport?

I have designed OLAP cube in Jaspersoft OLAP Designer. Now I have imported this Cube in iReport by making OLAP connection. I am tested my result set using following MDX query select HealthCheckStatusD.Members ON AXIS(0), {ChannelD.Members} ON…
Dhruv
  • 10,291
  • 18
  • 77
  • 126
0
votes
1 answer

No charts option in JasperServer Adhoc report from OLAP Connection?

I have made a OLAP cube using Jasper OLAP designer. Than I have made a OLAP connection using that OLAP schema in Jasper Server. My aim is to generate report using that OLAP cube. Basically the scheduled report in PDF format having tabular as well as…
Dhruv
  • 10,291
  • 18
  • 77
  • 126
1 2 3
…
54 55