Stack Overflow
Stack Overflow

Questions tagged [mdx-query]

A sample MDX query looks like below. 

[ WITH <SELECT WITH clause> [ , <SELECT WITH clause> ... ] ]   
SELECT [ * | ( <SELECT query axis clause>   
    [ , <SELECT query axis clause> ... ] ) ]  
FROM <SELECT subcube clause>   
[ <SELECT slicer axis clause> ]  
[ <SELECT cell property list clause> ]
140 questions
0
votes
1 answer

Trim Parameter value in mdx : How-to-pass-particular-string-name-in-mdx-parameter

i have an input parameter value "Europe - DMS Finland". but i need to input only finland to the mdx query to fetch the required data result. i have tried this in where condition in mdx: where strtomember((right(@ManagementGroup,7))) but still the…
Binny
  • 101
  • 1
  • 6
0
votes
1 answer

Deleting data from SSAS within a time range using c#

I am trying to delete particular data in my SSAS database, e.g I have data for one month and I want to delete data for one day only within this month, how can I do it using MDX query or c#? Note: I want to delete the day data from the database and…
ibrahim noureddine
  • 99
  • 1
  • 1
  • 11
0
votes
1 answer

Create Calculated Measure based on dimension filter condtion

I am trying to create a new calculated measure in my cube based on a dimension attribute value. Fact and Dimension table looks like below. So, far below MDX script is generated from the form view. SELECT NON EMPTY { [Measures].[FactCount] } ON…
Anil
  • 136
  • 1
  • 12
-1
votes
1 answer

I have some MDX Code that I cannot understand

I have found this code below, works just fine in the variant of MDX that I'm using ( Cognos TM1 ), but I can't seem to understand how it works. what value is name give to be able to be compared to the character "}" [}Dimensions].CurrentMember.Name <…
JDLove
  • 1
  • 1
-1
votes
1 answer

basic mdx question using Ms Excel OLAP tools

I will make this question and scenario as basic as possible since I have no background on programming. How do I make a script where all red will be multiplied by 5, yellow by 6 and blue by 7? The new measure will aggregate in grand total. I don't…
user10454387
  • 1
  • 2
1 2 3
…
9
10