Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to rounding up to next integer value In MDX

Status
Not open for further replies.
burakcan

burakcan

Programmer
Oct 10, 2011
39
0
0
CA
Hello,

Can anyone help me in my MDX query?
I am working on a calculated members in the cube. I need to round up the result to the next integer value.
Please see the samples below :

If my calculation result is 34.2 then round up to 35
If my calculation result is 34.6 then round up to 35 again.

Here is my calculated member calculation :

[Measures].[TotalCalendarTimeInDays]/ IIF([Measures].[TotalFundedApplication] = 0 , 1,[Measures].[TotalFundedApplication])

Any help will be greatly appreciated!

Thanks
 
Status
Not open for further replies.

Similar threads

Komal0735
  • Locked
  • Question
how to perform partial cube processing without losing data - SSAS, SSIS
Replies
0
Views
65
Komal0735
Komal0735
burakcan
  • Locked
  • Question
How to hide unwanted dimension values in SSAS cube
Replies
1
Views
118
Motlatjo
Motlatjo
tcstl1
  • Locked
  • Question
Migrating SSAS to new server
Replies
0
Views
58
tcstl1
tcstl1
KumarD
  • Locked
  • Question
How to externally access data warehouse - is SSAS needed?
Replies
1
Views
68
johnherman
johnherman
JP_Quinn
  • Locked
  • Question
Adding New Column to Dimension Table, Used in Other Cubes, Must I Update the Models of Other Cubes?
Replies
0
Views
78
JP_Quinn
JP_Quinn

Part and Inventory Search

Sponsor

Back
Top