813 questions
1
vote
0
answers
88
views
Filter a pivot table for multiple values
I have VBA code, coded by someone else, to filter an OLAP pivot table.
I want to filter for multiple trade dates rather than one.
I am aware that .CurrentPageName doesn't allow for multiple values. ...
0
votes
0
answers
72
views
How does the MDX GENERATE function work with sets?
I am currently studying MDX language to query data in Cube. While reading the documentation for the MDX GENERATE function, I encountered some confusion about how it works.
Here is some context about ...
- 67
1
vote
1
answer
605
views
How to configure Cube.js pre-aggregations to refresh every 12 hours or at a specific time (e.g., 4:00 AM UTC)?
I’m working on a Cube.js project where I need to configure pre-aggregations to refresh at regular intervals, specifically every 12 hours or at a specific time like 4:00 AM UTC. I’ve set up a cube to ...
0
votes
0
answers
45
views
Finding shorter solution for the grouping
I've got solution for the aggregations I'm looking for, however I believe there is a shorter way to achieve same output with a single query.
The engine is RedShift.
select
a
,null as b
...
- 16
0
votes
0
answers
694
views
SSAS CUBE connection from Visual Studio
I am trying to connect to my local database Comms from Visual Studio on an analysis services project for creating a cube.
When I make connection on data source and test the connection I get this error ...
- 19
-3
votes
1
answer
43
views
I cant change the brand name for total product
i cant seem to change the brand name for total product example is Apple to Grand Total for Apple
I am having a problem with my code this is my code
SELECT Month(PurchaseDate) AS 'Month',CASE
WHEN ...
0
votes
0
answers
66
views
How to create report in SSRS using two parameters from one dimension
I would like to create report as below:
https://i.sstatic.net/b5VCe.png
The first section of columns contain costs of:
November 2020
November 2021
November budget 2021
The second section of colums ...
1
vote
0
answers
43
views
DrillDownLevel causing rows to be duplicates
I have defined a cube with a hieararchy of Dates such: Year is a top level then there's Month level.
I have deployed the cube using SSAS VS 2022 and SQL Server 2019.
But when I query it using the ...
- 581
1
vote
1
answer
386
views
difference between default and Full Processing
I'm trying to understand how processing a cube in default mode vs. a full process is different for SQL Server Olap cubes. This article gives a brief description of each
https://learn.microsoft.com/en-...
- 67
0
votes
1
answer
62
views
how to get previous value in a fact table for a measure in mdx
I want to write an mdx query with a calculated Measure.
Here is my fact table:
How to implement a mesaure with the rule below :
If CurrentAtt != PreviousAtt then PreviousValue
else CurrentValue
Thank ...
0
votes
0
answers
303
views
OLAP queries in MySql
I am trying to implement OLAP queries in MySql.
Here is a relation that I am trying to implement queries on
Cart(product_name,shipper_name,quantity).
I tried running the following query:
select ...
0
votes
1
answer
184
views
What is the equivalent of union in MDX?
Im having to create a procedure/Function that returns an mdx query. This query is supposed to return a metric that is based on a year in a date range. EX- if a user asks for data from 2021-03-01 to ...
- 67
1
vote
1
answer
751
views
Filter Cubeset based on dimension & measure
I have a created a cube with different tables - Product Master,Sales Details,Calendar table.
I want to apply filter to cubeset function of Excel, using MDX expression.
I'm confused & result are ...
1
vote
1
answer
157
views
Can you create text based calculated members in SSAS
Is is possible to have a calculated member that shows text instead of numerical values.For instance, classifying customers by the product they bought into Platinum, gold, silver and bronze.
Is it ...
- 43
0
votes
1
answer
554
views
Data aggregation in Redshift to improve performance
I'm using heavily loaded Redshift cluster with some complex views that joins huge tables, during the pick hours many user query these views which is causing some performance issues, I used metalized ...
- 456
0
votes
1
answer
264
views
How to clear data from Excel pivot table while keeping connection
My Excel pivot table connects to external data source (OLAP cube) via windows authentication. I would like to make changes to my pivot table and share/publish the workbook. Since there is row security ...
3
votes
1
answer
99
views
Exponential moving average in MDX
I have bellow output of cube
date value
---- -----------
2021-01-06 10
2021-01-07 Null
2021-01-08 Null
2021-01-09 15
2021-01-10 18
2021-01-11 25
My question is, ...
- 2,739
0
votes
1
answer
415
views
Where can I run MDX Queries on macOS?
I searched and found that there is only SQL server (Microsoft) that can execute MDX queries, and unfortunately it is not compatible with macOS. Are there relative apps or environments that I could ...
-1
votes
1
answer
691
views
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 ...
- 55
1
vote
1
answer
603
views
Total Sum of Calculated member is wrong
I have there tables:
Artikal (eng. Item)
Grupa (eng. Group)
Potrosnja (eng. Consumption)
Potrosnja is my Measure table and Artikal is Dimension. Grupa contains also a parent-child relationship ...
- 45
1
vote
0
answers
31
views
MDX - sum on related stores
help with MDX query
please
i need to
calculated stock pcs
for current member
as sum of SAME region
and only for distribution centers
for example
first row Object = 'WH_1'
Region = 'A'
i need to get ...
- 51
0
votes
0
answers
205
views
How do I add a second condition to current exists function in a CubeMember function to return the ID field
Hi I was wondering if there was a way to apply two conditions to an Excel 365 CubeMember function.
I currently have an old query that was poorly written and fails when when there are two sub account ...
- 13
1
vote
2
answers
8k
views
where is OLAP in powerBI
I am new to Business Inteligence and powerBI
I understand the need of warehouses and dimension modeling
My question is once the datawarehouse is created (in my case using oracle) i can connect it to ...
- 73
1
vote
1
answer
459
views
MDX get data from multiple dimensions without measure
I have an OLAP cube with many dimensions. I am trying to retrieve related data from two of them. The problem is that this cube does not have any measures, so I'm not sure how to work with it. As a ...
- 109
1
vote
1
answer
1k
views
Filter OLAP pivot table with VBA
I have access to our database through an OLAP pivottable. I often want to filter based on multiple client numbers (which are not continuous). The client list is so long, however, that trying to scroll ...
- 61