All Questions

3
votes
3answers
6488 views

Star schema [fact 1:n dimension]...how?

I am a newcomer to data warehouses and have what I hope is an easy question about building a star schema: If I have a fact table where a fact record naturally has a one-to-many relationship with a si...
0
votes
1answers
1593 views

Linked server dynamic catalog for executing MDX through OpenQuery

I have multiple OLAP databases in my project, so is it possible to dynamically decide the catalog for executing this MDX query? SELECT * FROM OpenQuery(OLAP_SERVER, 'WITH MEMBER measures.X AS dimensi...
3
votes
1answers
765 views

Connecting to Analysis Services from R or Nodejs

I am trying to connect Analysis services from either through R or Nodejs. For R, I have found the following library: https://github.com/overcoil/X4R For Nodejs, I have found the following library:...
3
votes
4answers
15365 views

Get SSAS cube last process time

In Excel I make an Analysis Services connection to a data cube. I would like to be able to show a user how current the data is by showing them when the last cube processing time occurred. Making an an...
2
votes
1answers
786 views

What makes access to OLAP Cubes / Datamarts and similar datastructures, faster than to relational databases?

What makes access to OLAP Cubes/Datamarts and similar datastructures, faster than to relational databases? EDIT A bounty of 200 will be provided asap.
2
votes
2answers
2534 views

Calculated measure/dimension

I'm relatively new to MDX and am trying to accomplish what I think should be an easy thing, but I haven't found any solution. I have a sales cube and one of the measure is profit which can be negativ...
2
votes
1answers
5808 views

Hadoop connectivity with SAS

I want to use SAS/ACESS 9.3M2 Interface for connecting sas with my Hive. My question is, whether sas imports hive cubes into sas environment and queries there? or, It again hits hive for the purpose...
8
votes
1answers
2633 views

Connecting to a SSAS cube using R

Is it possible to query a SQL Server Analysis Services cube using R? I have this cube on a different external Server and i am working from my machine but i have admin privileges on the Server with my ...
5
votes
1answers
5615 views

SSAS cube with multiple DB

I have 3 databases with the same structure, but different data, since they are from different clients. Now, I have an existing SSAS project. Its Data Source Views, Cubes and Dimensions can only use o...
3
votes
1answers
186 views

How to get back aggregate values across 2 dimensions using Python Cubes?

Situation Using Python 3, Django 1.9, Cubes 1.1, and Postgres 9.5. These are my datatables in pictorial form: The same in text format: Store table ------------------------------ | id | code | a...

Previous Next