Questions tagged [olap]

Online Analytical Processing (OLAP) is a category of software tools that provides analysis of data stored in a database, optimized for querying and reporting. OLAP tools enable users to analyze different dimensions of multidimensional data stored for rapid access. For example, it provides time series and trend analysis views.

0
votes
0answers
3 views

Are there some embeded database for OLAP?

What I mean is embed some OLAP database to smart phones or some IOT devices by optimizing stores and network protocols.
0
votes
0answers
8 views

Dimension attribute assigned to diferent keys than in database

Basicaly, I have a dimension in OLAP cube in Visual Studio with several attributes. -MainKey (WChar) -OrderKey (BigInt) - for specific ordering of attributes -ProblematicAtt - this is the ...
0
votes
0answers
9 views

I'm having a error while building a Cube in Apache Kylin

See the Logs in the Step one: java.io.IOException: OS command error exit with return code: 127, error message: Logging initialized using configuration in jar:file:/home/jefferson/Developer/apache-...
0
votes
0answers
27 views

Sort Excel Pivot Table with multiple rows and one value colum

I am trying to sort an Excel Pivot table by a final value. The pivot table gets its data from an OLAP data source (SSAS). I will try to explain the problem with the help of a simple example. Suppose ...
0
votes
0answers
10 views

Why Mondrian executes so many SQL before getting results?

Mondrian seems to run a lot of groupby sqls before getting the aggregation results, such as select `t`.`year` as `c0` from `table` as `t` where UPPER(`t`.`c0`) = UPPER('1997') group by ...
0
votes
1answer
31 views

What is the relationship between keys in OLAP and OLTP systems?

What is the relationship between keys in OLAP and OLTP systems? Why should OLAP's dimensions have the foreign key that refers to the primary key in operational (OLTP) systems?
0
votes
1answer
52 views

Accounting Data Warehouse Design Question

The finance module in our ERP has a general ledger and sub-ledgers (accounts receivable, accounts payable etc.). All the sub-ledgers are rolled up into the GL. Standard accounting schema I believe I ...
0
votes
0answers
17 views

Disable “Analysis Services Connection 14.0” Dialog Box

Want to trap any errors on an OLEDBConnection due to user credentials or permissions, but MSOLAP.8 ("Analysis Services Connection 14.0") always prompts for corrected settings. As a workaround, I can ...
0
votes
0answers
27 views

How to deploy OLAP XMLA file in Microsoft Azure Analysis Service using Python

I am trying to deploy a OLAP XMLA file to Azure Analysis Service using Python after modifying certain parameters in it. I am not able to find any python code snippets which helps to connect Azure ...
3
votes
2answers
46 views

Connect to Power BI XMLA endpoint with Python

Since the announcement about XMLA endpoints, I've been trying to figure out how to connect to a URL of the form powerbi://api.powerbi.com/v1.0/myorg/[workspace name] as an SSAS OLAP cube via Python, ...
0
votes
0answers
18 views

An exception occurred processing [/testpage.jsp] at line [91]

I Am trying to install Mondrian using tomcat and mysql Here is the link to tutorial iam following: http://hamdihasnaoui.weebly.com/tutorials/instalation-and-confuguration edit: I have attached an ...
0
votes
0answers
24 views

How to Loop in Slicer in vba

Im trying to use an old code to run with another new slicer. I need a code that loops in a slicer, for each selected item make a copy of this data for another sheet Ive tryied the old cod, but my ...
0
votes
0answers
16 views

Measure slice or filter in power BI using SQL Server OLAP

I have OLAP data using SQL Server that live connected with Power BI. In that data, i have measure that called GPA (range 0 - 4.00), it's college students GPA data. I want to slice or filter the GPA ...
1
vote
1answer
44 views

ClickHouse Unknown Codec Family Error on Version Update

I have been working on a three node ClickHouse Cluster with a Table created using ReplicatedMergeTree. I recently updated one of its nodes from version 18.14.2 to 19.3.7. However, after the upgrade, I ...
0
votes
1answer
27 views

How deep to go when denormalising

I denormalising a OLTP database for use in a DWH. At the moment I am denormalising studygroups. Each studygroup has a key pointing towards 1 project. Each project has a key pointing towards 1 ...
0
votes
0answers
22 views

Two dimensions in a cube don't connect to each other

I have a problem in SSAS with my cube, where I have 2 dimensions and a fact table. The problem is, when I want to analyze expenses for each employee, and from which department that employee is, none ...
0
votes
1answer
39 views

Saiku/Hitachi-Pentaho Schema Workbench

I'm using the Schema Workbench that I compiled from the source available on github using: mvn -Pworkbench package It starts with no problem and there is a folder called drivers which suggests to ...
0
votes
2answers
94 views

Apache Druid vs Snowflake

I'm in the process of choosing the proper Tools for BI/OLAP, and need understand whether Snowflake is more suitable for my goals or maybe Druid is a better fit Currently I'm using Snowflake as my ...
3
votes
2answers
46 views

How to show dimension members for which there are no values in fact in SSAS Multi-Dimensional?

I have two tables in my Ticket Management Application, "ExpositionPeriods" and "OrganisedVisits". ExpositionPeriods - Defines the periods for which tickets can be purchased. OrganisedVisits - Stores ...
0
votes
1answer
160 views

Python Connect to Microsoft Analysis Service

I want to connect to Microsoft Analysis Server via Python. I have seen you can do this by the package xmla or olapy, but both of them required the Analysis Server to be in HTTP, which is not ...
1
vote
0answers
22 views

Wrong SUM calculations in OLAP cube

I'm pretty new to SSAS and i have encountered a quite odd issue. The simple SUM function in OLAP cube shows wrong numbers based on the dimension usage. I have created simple OLAP cube in SSAS, which ...
0
votes
2answers
27 views

How to do OLAP analyse after building the Data Warehouse?

We have built a data warehouse which contains multiple fact tables and multiple dimension tables (on a MySQL server). What is the next step to do the OLAP operations? I read an answer says that OLAP ...
-1
votes
1answer
37 views

Exploring Apache Kylin cubes with Power BI?

I had some conflicts with my teammates about if it is really the Power BI can read and explore Apache Kylin Cubes or it is just exploring the Data source, I had some problems with saiku exactly in ...
0
votes
1answer
23 views

Should we put all the fields related to the `user` in a `dim_user` table in a data warehouse?

Considering there is a data warehouse contains one fact table and three dimension tables. Fact table: fact_orders Dimension tables: dim_user dim_product dim_date All the data of these tables are ...
0
votes
1answer
14 views

OLAP Cubes - When dimension has been read/accessed last time

Is there any way to see when OLAP cube dimension has been read accessed last time ? Is that information held anywhere ? Thanks
1
vote
0answers
45 views

Build Uber like data model for OLAP

I am building up data model and I was trying a data model for Rideshare Here is what I have so far Trip Fare Fact table Timestamp TripId DriverId RiderId TripStatus(Cancelled_by_driver, ...
0
votes
0answers
16 views

Same SSAS cube has different drive sizes in two identical environment

I have a PROD SSAS cube that I restored on QA SSAS VM. Both QA and PROD VMs are on same windows OS level AND SSAS version. Both QA and PROD also have the same solution deployed to this cube. They both ...
0
votes
1answer
56 views

Creating an MDX measure in Excel to count members of one dimension based on another dimension

I am trying to create an MDX measure in Excel (in OLAP Tools) that will count how many members there are for every other item in another dimension. As I don't know the exact syntax and notation for ...
0
votes
0answers
7 views

Connect running sparkube cube to MS Power BI

I have exposed a Sparkube and can access it via Excel or UI. Now, I try to use the cube as a datasource for MS Power BI. However, every time I try to establish the connect from MS Power BI, I get a ...
0
votes
1answer
39 views

Can the same dimension table be related to multiple fact tables?

I am new to OLAP,if I have two fact tables can they share the same dimension table? A good example would be if I have tables fact1 and fact2, can they both have a foreign key into a single Date ...
0
votes
0answers
32 views

Error in SSMS when connecting to SSAS through msmdpump.dll

I configured an HTTP interface through msmdpump.dll for an SSAS instance I have. Last week it was working and I could connect using SSMS to the SSAS through this URL, but today I can't. The only thing ...
0
votes
0answers
15 views

Visual Studio Crashing in SSAS while trying to add a Role to my OLAP Cube

As stated in the title Visual Studio crashes when i try to add a role to my cube. The deployment is successfull and everything goes fine concerning the cube functionalities. What I do is going to the ...
2
votes
1answer
54 views

PostgreSQL function returning a data cube

First off, the iceberg-cube query is defined as in Let's say I have a relation item,location,year,supplier,unit_sales, and I would like to write a plpgsql functions as a wrapper around the query in ...
1
vote
1answer
40 views

Return 'n' rows from MDX output

How to filter MDX output for first 'n' rows and then loop over the next 'n' rows and so on using following example. SELECT { [Measures1].members, [Measures2].members } ON COLUMNS, { [Date]....
0
votes
2answers
47 views

How to translate a scalar subquery into a conditional OLAP function in SQL?

I am using Teradata 15.10. I have a table with two columns last_name and first_name. For each row, I need to count how many others rows have the same last_name and first_name, but with the values ...
0
votes
1answer
100 views

custom partition in clickhouse

I have several questions about custom partitioning in clickhouse. Background: i am trying to build a TSDB on top of clickhouse. We need to support very large batch write and complicated OLAP read. ...
0
votes
0answers
14 views

New Data Sources creator doesn't start in Visual Studio 2017

I try create new OLAP in visual studio 2017 and I created Analysis Services Multidimensional .... Project and when I click Project ->New Data Source... just open "Welcome to the Data Source Wizard" ...
0
votes
1answer
34 views

SSAS - Problem with summarizing in OLAP SSAS - diffenent than in database

I have one problem with my OLAP CUBE. Before it was ok, but recently in my database I add a new dimension. Off course I did another import and every data in database is ok. Then I built new OLAP CUBE ...
0
votes
1answer
25 views

OLAP filtering hierarchy confusion

I'm trying to use specified values within my file to determine the filters to apply to my OLAP pivot but I'm struggling to notate the custom array correctly due to the Hierarchy that exists. When ...
2
votes
1answer
48 views

SSAS OLAP Cube - Sum measure only works when keys are present

(This is a mock of my actual setup to help me figure out the problem.) I have one fact table and one dimension table, linked by an id field. My goal is to make a measure that sums up all "...
2
votes
0answers
38 views

No data found exception using oracle olapi

i started experimenting with oracle olap api 'olapi', but i'm having some issues while running their examples package. when i run MakingQueriesExamples.java in source package i get this error: oracle....
0
votes
0answers
29 views

Totals and Subtotals in OLAP Database Design

I'm building a fairly classic Salesforce pipeline tracking dataset for my company's analytics team. I'm trying to design using OLAP principles but my background in building OLTP databases for internal ...
1
vote
2answers
164 views

Dimensional modeling on columnar databases

I have started learning cloud architecture and found out that they all are using columnar databases which claims to be more efficient as they are storing column rather than a row to reduce duplicate. ...
0
votes
0answers
23 views

Olap http request Dax paging

I have my tabular model on remote server and use a msdnpump to talk to it over https.I use this envelope: <Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/"> <Body> &...
0
votes
3answers
556 views

Missing method in Visual Studio when trying to process OLAP cube

I have got SSMS v 17.9.1 and Visual Studio 2017 v 17.9.1 installed. I have created many olap cubes so far but today a new issue surfaced. Trying to process the newly created cube, I've got the ...
0
votes
1answer
70 views

MDX Invalid token, Line 3, Offset 74,

I'm quite new to MDX but learning by the power of Google! I have the below statement: WITH MEMBER _X AS Sum ( ( [Time].[Week].CurrentMember:[Time].[Week].CurrentMember.Lag ( [Measures].[Normalised ...
0
votes
1answer
47 views

Link Project and R Version

I have two different versions of R installed, one which is up to date and which I use for all my regular R coding (needs to be up to date so that I can use various updated and new packages) and one ...
0
votes
0answers
34 views

Access SSAS 2016 with ADOMD 2.8

We have an old VB6 based OLAP front end and thus are stuck with ADOMD Version 2.8. Until SSAS 2012 we didn't have any problems. At the moment we evaluate migration to SSAS 2016, and it turns out ...
0
votes
0answers
17 views

how to combine two attributes on dynamic security control for parent child model

there is an issue with an OLAP dimension dynamic security role setup. I'm using parent-child model on olap for this dimension. I prepared permission control table via ETL process which stores access ...
0
votes
1answer
61 views

MDX CASE Statement in EXCEL

I am accessing a data in an OLAP cube in excel and trying to use an MDX query to create a new calculated measure in my PivotTable. Based on the container size I need to calculate the capacity for ...