1,342 questions
0
votes
0
answers
23
views
Alternative PowerShell Solution To Running MDX on a Power Bi Semantic Model Hosted In A Fabric Workspace
So we want to do this, but it's not supported. So we must pursue a alternative solution. Optimally this would something that could be run from SQL Server directly with minimal external code possible.
...
- 2,614
-1
votes
0
answers
15
views
How to Create the Rotating "B Cube" Effect from Bridge Theme Demo?
I’m trying to replicate a specific effect from the Bridge theme demo. You can check out the page here: https://bridgelanding.qodeinteractive.com/tour/.
In this demo, there’s a section where, as you ...
0
votes
0
answers
14
views
SSAS return multiple date
There is a date attribute in the SSAS membership card file dimension, called "valid date to end date". Select the attributes of the member master file, the membership card file's "valid ...
- 11
1
vote
1
answer
35
views
Pyspark - cube aggregation
I'm trying to use the cube function in pyspark without including all the columns in the cube.
SQL equivalent of what I am trying to achieve:
select col1, col2, col3, sum(col4) from table
group by ...
- 453
1
vote
1
answer
32
views
SSAS CUBE Import Into Power BI Desktop
I'm new to SSAS Cube data and structures. I'm trying to import the fields I need for a dashboard into Power BI, but I can't shorten my date field in the original request.
I tried filtering the data ...
- 21
0
votes
0
answers
37
views
Cubejs pre_aggregations not working for BigQuery tables
In a cubejs setup with CUBEJS_DEV_MODE ON, facing issue setting up pre_aggregations on BigQuery cubes:
pre_aggregation has a refresh_key set for every day refresh as :
refresh_key:
sql: "...
- 93
0
votes
0
answers
15
views
How can I build a preaggregation that is able to query a cube with a filter on its joins cube?
For simplicity:
I have 2 cubes, Order and OrderItem.
Order has many OrderItem.
OrderItem has a dimension called status.
self hosting cube
Goal: Query for Orders with a dynamic filter on OrderItem ...
0
votes
1
answer
101
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
33
views
using cubejs with elasticsearch
I want to use Cube.js with Opensearch which is forked version of elasticsearch 7.x. I managed to establish the connection, but I couldn't find resources regarding the syntax. Are there people who use ...
- 1
0
votes
0
answers
42
views
If I want to write code in a register-level manner, which interrupt is enabled by default?
For example, if I want to write code without libraries, do I have to enable some system interrupts?
I know that in STM32-M3, the RESET, NMI, and Hard Fault interrupts are enabled by default. However, ...
1
vote
0
answers
55
views
CUBE functions not updating after query refresh
I have several workbooks which use CUBE functions which reference the Data Model. Up until recently these always worked fine; now, however, after performing a full refresh of the queries which feed ...
- 9,042
0
votes
0
answers
12
views
How to check schema, database, server in Cube SSAS by SQL code
I am trouble with my tasks thatI want to list the tables, source schema, and database of Cubes in SSAS. Which query can help me find them without having to open the xml and search each line?
Hope ...
0
votes
0
answers
27
views
Reconfigure an existing SSAS Cube
How can I add new SQL table to an existing SSAS cube?
I’ve done an MDX query in SSMS to see the structure of the cube but I couldn't figure out how to add anything new. The existing SSAS cube has an ...
- 1
1
vote
1
answer
48
views
Not all the sides of the 3D cube display
I'm trying to create a 3D cube using CSS but not all sides of the cube appear as they should
the left , right and top sides of my cube doesn't display at all
only the front , bottom and backward of ...
- 21
0
votes
0
answers
26
views
Problem connecting Here3+ to orange cube+
I tried to follow the tutorial at http://www.worldronemarket.com/here-3-gps-manual/ and connected the red cables of the here3+ to the CAN1 of the cube board.
The next step would be to modify ...
- 11