Posted
by Espo
on Stack Overflow
See other posts from Stack Overflow
or by Espo
Published on 2010-06-04T12:11:39Z
Indexed on
2010/06/07
2:22 UTC
Read the original article
Hit count: 296
How can i round a calculated mdx measure up to the nearest integer without having Excel on the server? The Excel-function is CEILING(number, significance), but it is not possible to install Excel on the production ssas-server.
© Stack Overflow or respective owner
as seen on Programmers
- Search for 'Programmers'
I was watching http://www.joelonsoftware.com/items/2011/06/27.html and laughed at Jon Skeet joke about 0.3 not being 0.3. I personally never had problems with floats/decimals/doubles but then I remember I learned 6502 very early and never needed floats in most of my programs. The only time I used…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Mathematically, consider for this question the rational number
8725724278030350 / 2**48
where ** in the denominator denotes exponentiation, i.e. the denominator is 2 to the 48th power. (The fraction is not in lowest terms, reducible by 2.) This number is exactly representable as a System.Double…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi:
I have a stored procedure that rounds a column with dates in (yyyy:mm:dd hh:mM:ss) to the nearest 10 minute handle (yyyy:mm:dd hh:mM)
20100303 09:46:3000 ------ 20100303 09:50
but i want to chage it to round it off to the nearest 15 minute handle:
20100303 09:46:3000 ------20100303 09:45
here…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
How can i format a Double to String in c# so as to have only two decimal digits?
If I use String.Format("{0:0.00}%", myDoubleValue) the number is rounded, and i want a simple truncate without rounding. Also, I want the conversion to String to be culture sensitive.
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I've seen the following (bizarre) Javascript rounding function in some legacy code. After googling for it I can see that it crops up in a number of places online. However I can't work out why the hard-coded values 8191 and 10485 are present.
Does anyone know if there's any sensible reason why these…
>>> More
as seen on SQL Blog
- Search for 'SQL Blog'
Short version: the latest available version of MDX Studio can be downloaded from http://www.sqlbi.com/tools/mdx-studio/ Long version: Last week Stacia Misner twitted that the online version of MDX Studio was no longer available. It was hosted on http://mdx.mosha.com. It was a sad news, and it is…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Why aren't my results being filtered by the members from my [Group Hierarchy] returned via the filter() statment below?
SELECT
NON EMPTY {[Measures].[Group Count], [Measures].[Overall Group Count] } ON COLUMNS,
NON EMPTY {
[Survey].[Surveys By Year].[Survey Year].ALLMEMBERS…
>>> More
as seen on SQL Server Central
- Search for 'SQL Server Central'
To learn MDX, there is really no alternative to installing the system and trying out the statements, and experimenting. William Pearson, the well-known expert on MDX, kicks off a stairway series on this important topic by getting you running from a standing start.
NEW! SQL…
>>> More
as seen on SQL Blog
- Search for 'SQL Blog'
I just published the article Converting MDX to DAX – First Steps on the renewed SQLBI web site about converting MDX to DAX. The reason is that with BISM Tabular in Analysis Services 2012 you will be able to write queries in both DAX and MDX. If you already know MDX, you might wonder how to “translate”…
>>> More
as seen on SQL Blog
- Search for 'SQL Blog'
Jeffrey Wang wrote a great blog post about attribute overwriting in MDX that is very clear and full of helpful pictures to show what happens when you write an MDX statement that writes into your multidimensional space. This is very common in an MDX Script and if you tried to customize the DateTool…
>>> More
