3,970 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
0
votes
1
answer
21
views
Setting website link preview using react and mdx (each page of the website a separate image)
I have a website for example "example.com", and the main layout.jsx has below metadata.
export const metadata = {
title: {
template: '%s - example',
default: 'example - ...
- 1
0
votes
1
answer
16
views
MDX Returning Null Values Even With Non Empty
Good afternoon. Have an MDX query still returning null values even though I have non empty in the MDX. This query does run and it does return values where I would expect to see them. Trying to get rid ...
-2
votes
0
answers
22
views
Unable to extract UDA tagged to Account using MDX script in Essbase 21C
We are currently using Essbase 21C and trying to extract metadata using MDX script. Along with Metadata, we are also trying to extract UDA.
In the Essbase, Account1 is tagged with only one UDA which ...
- 63
0
votes
0
answers
23
views
Syntax error in mdx file when running docusaurus-mdx-checker
I run the check
npx docusaurus-mdx-checker
and got the error
Error while compiling file ../docs/concepts/data_versioning.mdx (Line=157 Column=2)
Details: Could not parse expression with acorn
this ...
0
votes
0
answers
8
views
Storyboard Docs "Copy Code" and "tags" integrations in custom docs pages
Storyboard Docs - "Copy Code" and "tags" integrations in custom doc pages
Hey, I'm new to Storybook. I'm currently displaying an array of components into a custom Docs page UI, but ...
- 350
1
vote
0
answers
27
views
Do OLAP Cube architecture include the unrequired tables to the queries?
I have an OLAP Cube created by relating about 40 tables(5 facts and 35 dimensions).
The question im interested in is if I query (select count(*) from tableA) to the SQL Server, should the result ...
- 11
1
vote
0
answers
28
views
MDX: Incorrect value using EXISTING
I am trying to use EXISTING to get the sum of multiple members being selected. Below is what I have. The MDX is not returning a syntax error but the numerical result is way off from what I need. Any ...
- 11
0
votes
0
answers
21
views
How to Use Sent Props in Code Block Filename in Nextra 3.0 MDX?
I'm currently using Nextra version 3.0.0-alpha.28 for my documentation, and I'm trying to pass props to an MDX component. Specifically, I'm sending a prop like this:
<CssVariablesReact filePath={&...
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
2
answers
102
views
import string into Astro MDX
I need to import a simple string into an astro starlight MDX file to show the latest version number. My code is basically
---
title Version Test
desc Show version
---
import VERSION from "/src/...
- 13k
0
votes
1
answer
118
views
how to render mdx in svelte
I'm building a blog using sveltekit + sqlite3, I want to store mdx content to database and render them dynamiclly
My solution is:
use mdsvex to compile .mdx to .svelte
use svelte to compile .svelte ...
- 1,629
0
votes
1
answer
28
views
Combining Members from Different Levels in the Same Hierarchy in MDX Query
I'm trying to write an MDX query in SSAS to combine two members from different levels of the same dimension/hierarchy in my filter, but I'm running into issues as they return no data. When I write ...
- 21
0
votes
0
answers
13
views
Create Calculated Member Status %
I have a cube which is a small log of telephone zones,
measure -> [Measures].[Calls Count]
dimension -> [CallStatus].[Status2].[Status].&[Busy]
[CallStatus].[Status2].[Status].&[Invalid]...
- 11
0
votes
0
answers
12
views
Union between tabular model and SQL table with MDX in Analysis Service
I have this query extracted from a tabular model:
SELECT NON EMPTY { [Measures].[Sales], [Measures].[Quantity Sold] } ON COLUMNS,
NON EMPTY {
([Invoice].[Number].[Number].ALLMEMBERS *
...
- 41