Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bridge
Yak Posting Veteran
93 Posts |
 Posted - 2005-04-25 : 05:14:00
|
| I am basically new to Analysis Services, I am trying to insert a Calculated Member as Percentage. Actually I have a cube for browser. The measurement column is UserID and dimension is browser. Want to know how many users are using which browser. and what is the percentage. Please help me in establishing a Percentage column. |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-04-25 : 17:44:18
|
| Create a calculated member: (Adjust the names of the measure&dimension to your cube)[Measures].[UserCount]/([Browser].[All Browsers],[Measures].[UserCount])Use format string #.#%rockmoose |
 |
|
|
bridge
Yak Posting Veteran
93 Posts |
Posted - 2005-04-26 : 00:52:11
|
| But as far I know the formula for percentage is(obtained / total) * 100So how this formula works, this is fine[Measures].[Userid]/([BrowserDimension].[All BrowserDimension])but I could not understand how, [Measures].[Userid] is being used |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-04-26 : 04:38:19
|
| The % in the format string does the /100.[Measures].[UserCount]/([Browser].[All Browsers],[Measures].[UserCount])The above MDX gives obtained/total - paraphrase:"(The value of the measure in current intersection of cube)"/"(The value of the measure at the top level of Browser dimension)"iow: "current"/"total"rockmoose |
|
|
|
|
|
|
How to add Percentage