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

Is it possible to set a cube with a snowflake schema in data.cube R?

Or, can dimensions be, in some way nested, in data.cube? Given the following example (accessed via ?data.cube on R, having installed last branch of data.cube-oop package, by @jangorecki) for which I post code and image example. Consider I want to…
MikeMajara
  • 922
  • 9
  • 23
2
votes
3 answers

How to replace null with 0 in SSAS cube

I need to replace null with 0 in my SSAS cube. what is the proper way to achieve that? This is my current query: SELECT {([Measures].[Employee Age Count])} ON COLUMNS, { ([Dim Gender].[Gender Name].[Gender Name].ALLMEMBERS * [Dim Age Ranges].[Age…
Suhandy Chow
  • 249
  • 1
  • 4
  • 14
2
votes
1 answer

Error when processing a cube that starts with: The DOM parser failed to load and parse the stream

I've just got a strange error from my SSAS cube when (re-)processing data. This is what it says: The DOM parser failed to load and parse the stream. URL:'' Reason: 'Illegal qualified name character. ' Source:''. File position: 0. Line: 1. Has…
darlove
  • 317
  • 2
  • 10
2
votes
1 answer

how to see or create the diagram from an existing SSAS cube?

I am new in SSAS. I am trying to figure out the diagram of the existing cube. Is there any way to see the diagram from the existing SSAS cube? Or can I create the diagram form that existing cube? Thanks
adarksun
  • 371
  • 1
  • 6
  • 20
2
votes
0 answers

How to add a metric for top n count in mdx

I want to create a metric which will show only the top 10 result whenever applied. Suppose the data is item Price A 20 B 45 C 50 D 80 E 10 F 90 G 85 H 55 I 40 J 100 I want to show the top 5 result in descending order. So, the expected result…
Tyler Durden
  • 207
  • 1
  • 5
  • 10
2
votes
2 answers

distinct count in SSAS

I have 4 columns in a fact order table OrderDescriptionID, OrderID, CustomerID, and DateKey. The data in the rows is such that orderID defines 1 order by a customer. If the customer has placed one order with multiple items then the…
Faiz
  • 69
  • 1
  • 1
  • 9
2
votes
1 answer

How to resolve "MSOLAP.4 Provider is not registered on the local machine" error without install SQL in local machine?

If I am run OLAP application in SQL installed machine (Machine A), it will work perfectly. But I need to run that application in another machine (Machine B) with Machine A's MSOLAP DLL. Is it possible? If yes how can I do that? Update I have fixed…
LTA
  • 191
  • 3
  • 16
2
votes
0 answers

python cubes analytical workspace list_cubes() fails

The current analytical workspace code seems to have some import error. I tried this .. from cubes import Workspace workspace = Workspace(config="slicer.ini") workspace.import_model("model.json") workspace.list_cubes() And I get this…
Software Mechanic
  • 974
  • 2
  • 9
  • 25
2
votes
1 answer

InMemory Option in SSAS MultiDimensional

Messing around with the storage options in a test SSAS Multidimensional model in SSDT on my home computer in sql server 2012 developer edition, and looking at the different partition storage options. If you pick the normal storage settings…
Brandon Frenchak
  • 486
  • 4
  • 12
2
votes
2 answers

SSAS: How to recreate and populate time dimension SQL table

Is there any command or tool that can recreate the schema and fill the needed time data into the time dimension SQL Table for deployment reason? I'm currently facing the issue that only during designing the time dimension SQL Table the wizard is…
Chris Richner
  • 2,863
  • 2
  • 26
  • 38
2
votes
2 answers

MDX - set member by another member values

I have this table generated with MDX. http://i62.tinypic.com/2m5xeg0.jpg I need to create a calculated dimension (or a measure) called "this year" with 2 values: YES: if currentmember YEAR includes value 2015 and NO: if member YEAR does not…
Eliza M
  • 107
  • 9
2
votes
1 answer

Olap cube calculated member, how to round

I created a calculated member and his value is: [Measures].[Value] / [Measures].[Recuento Fact Result] I want to round that value, and save only the first two decimals, for example: [Measures].[Value]=10 [Measures].[Recuento Fact Result]=3 My…
Ibon
  • 41
  • 5
2
votes
2 answers

SSAS Dimension Attributes are not visible in Cube Browser (BIDS)

I am new to SSAS & Modifying the existing SSAS Cube to Add New Columns, Rename and Delete Existing Columns. I Made required changes in the Data Source. I Refreshed the Data Source View and able to see the new changes. I Added the new columns in the…
user1089783
  • 63
  • 2
  • 8
2
votes
2 answers

MDX query to pivot table based on condition

I'm trying to write MDX query for pivot table. Similar query in RDBMS is like this: SELECT stats_Date ,ISNULL(SUM(clicks), 0) AS clicks ,ISNULL(SUM(CASE WHEN ad_type IN (1,3) THEN clicks END), 0) AS keyword_clicks …
Omesh
  • 27,801
  • 6
  • 42
  • 51
2
votes
1 answer

Can a SQL Server OLAP cube be loaded from csv files

I have never used or implemented an OLAP cube before, so I'm basically a beginner with this technology. I am analyzing a project that is converting scanned documents to an on-line MS SQL Server database. From the research I have done, OLAP cubes…
Bob Bryan
  • 3,687
  • 1
  • 32
  • 45
1 2 3
…
54 55