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

Pivot Tables - VBA

I want to select some values through VBA in Pivot Table which is linked to OLAP Cube. As I know such modification can be realised by typing: ActiveSheet.PivotTables("PivotTable1").PivotFields("[parameter].[parameter]").VisibleItemsList =…
matandked
  • 1,527
  • 4
  • 26
  • 51
0
votes
1 answer

Custom Interval In Dimension

I'm looking for recommendations on a best practice here. I have a requirement where on a given day I must have an arbitrary number of intervals (think buckets of time which are composed of transactions) where I can have at most N intervals per day.…
Dave
  • 2,386
  • 1
  • 20
  • 38
0
votes
2 answers

SQL OLAP Cube and dimension

In a windows Server 2008, using SQL server 2005, Visual Studio and SQL Server Analysis Services i created an OLAP Cube. The scenario is a typical store with sell products, customer and agents. The cube is made by a fact table tblVendite (sell data)…
Luka Milani
  • 1,541
  • 14
  • 21
0
votes
1 answer

Calculate database size in Oracle Essbase

Classical question at tests: I have 4 dimensions: Markets: Sparse, 10 stored members, 10 total members Products: Sparse, 5 stored members, 7 total members Accounts: Dense , 10 stored members, 11 total members Time : Dense, 5 stored, 12 total What is…
David Kakauridze
  • 305
  • 4
  • 11
  • 23
-1
votes
1 answer

Cannot connect SSAS Server to Power BI

I would like to connect my cube from SSAS to Power BI Desktop (Direct connection) but I can't access to the server of SSAS.. I get this: "The server you are trying to connect to does not have templates or you do not have permission to access it" I…
dadija
  • 1
  • 1
-1
votes
1 answer

ssas cube not showing all dimension members

Do you have any clues why excel is presenting more dimention members when i add measures to grid? When there is no measure selected then there is for example 3 members visible, when I add some measure then there is 5 and with next measure there is 6…
skk
  • 45
  • 5
-1
votes
1 answer

Load Excel into cube SSAS

I have a cube in SQL Server Analysis Services (SSAS) and I would like to be able to load the data that I have in an Excel file in the cube, is it possible to connect it?
Johan C
  • 29
  • 6
-1
votes
1 answer

Filtering doesn`t work on three level dimension

can someone help me out maybe? I have the following mdx: and the following structure of the Relationship dimension: And when in excel I try to filter on the attribute hierarchy: User Story Team, it only works for the two level user hierarchy…
Lena Meer
  • 79
  • 9
-1
votes
1 answer

How to connect Kyvos cube (Bigdata Cube) in Excel?

How to connect Kyvos cube (Bigdata Cube) in Excel
Rajiv Singh
  • 958
  • 1
  • 9
  • 14
-1
votes
1 answer

How Do I Represent An OLAP 4D Cuboid?

I am going through the exercise posted below. I don't quite understand how to represent the 4th dimension on paper. If it was just customer, date, product that will be straightforward. Do I have to rollup on something in order to get the fourth…
Edoardo Moreni
  • 408
  • 2
  • 10
  • 24
-1
votes
1 answer

SSAS get active record count between two dates

Can you please let me know the best approach for designing Data ware house and dimension modelling (SSAS cube) based on below requirement. Requirement here is, I have to get the student count which are active as of that month, if the user selects…
Rathnam
  • 1
-1
votes
1 answer

Calculated member for dimensions

Firstly gonna show you example. We've got a fact table with some id, which is not primary key. Also we have dimension with all ids from fact table and names for that. Our id from fact table is a measure with aggregation function max. Is it possible…
Dmitriy Kravchuk
  • 85
  • 1
  • 10
-1
votes
1 answer

MDX query for hierarchical report using hiearchical and flat dimension

My goal is to get a grouped report based on a MDX query on a OLAP cube. The report should be grouped on a hierarchical dimension Location and a flat dimension Category. As a newbie I struggle to write a correct MDX query to get the expected…
Thomas Zweifel
  • 627
  • 1
  • 6
  • 19
-1
votes
1 answer

Transform Numbers to Text

A field in my cube contains numerical values which I would like transformed and displayed as text. For example 1 is a sale 2 is a return etc Is a named caculation best?
SQ-what
  • 49
  • 5
-1
votes
1 answer

Star schema imperative for using Mondrian?

I am seeing different implied answers to this question. Can a single 'flat' fact table be used simply referencing the different columns from the Mondrian schema?
Forward
  • 9
  • 2
1 2 3
…
54
55