| Author |
 Topic  |
|
|
jasonp
South Africa
7 Posts |
 Posted - 09/04/2017 : 01:20:36
|
Hi,
Our OLAP Cubes have format strings that include currency, eg: $ #,#,
Our Local currency is in ZAR, so a value would show as: R 3 254 if the actual value in the cube is: 3253689
When we connect to the cubes with excel or local applications, everything seems to pick up off the local locale and apply the currency correctly.
When we use the report portal it comes through as $ ? any idea how we can resolve this?
I have tried Enabling Server Server Formatting on the Settings->OLAP Report.
I tried changing the language on the XMLA connection from none to English (South Africa) but when i update the connection it doesn't keep that setting?
Anywhere else i should be looking?
Thanks.
|
|
|
admin
1635 Posts |
|
|
jasonp
South Africa
7 Posts |
Posted - 09/04/2017 : 06:54:24
|
Thanks.. Doesn't resolve the issue though.. i can however now set the XMLA connection to English - 9 - i didn't have a problem with the string format being applied, ie: the rounding and showin in millions..
The Currency however is still an issue..does the $ naturally convert to the currency of choice like connecting to OLAP cube using excel for example..
not sure where else to check now? |
 |
|
|
admin
1635 Posts |
Posted - 09/04/2017 : 21:40:23
|
Please try:
Calculate;
Language (this) = 7177;
Where 7177 is the Microsoft LCID code for South Africa.
|
|
|
|
jasonp
South Africa
7 Posts |
Posted - 09/05/2017 : 05:53:53
|
| Where does this go? |
|
|
|
marco
Netherlands
588 Posts |
Posted - 09/05/2017 : 06:28:15
|
I have made a new OLAP Report on the ReportPortal Demo server:
With values without currecny sign, usd sign, eur sign and zar sign.
You can go to the Demo server and start the report and see the way how it is going on by yourself:
http://www.reportportal.us/reportportal/Proxy.aspx?reportId=1986
Is this what you would like to have ?
Marco |
|
|
|
jasonp
South Africa
7 Posts |
Posted - 09/05/2017 : 06:32:34
|
I think this is moving in the right direction.. is the currency being applied in the MDX query or do i lose all the format strings that have been applied in the cube measures?
where/how did you do that? |
|
|
|
marco
Netherlands
588 Posts |
Posted - 09/05/2017 : 06:57:12
|
| You can add it in the frontend or if you like on the backend in the olap cube by adding a measure / calculated measure with zar als currency sign. |
|
|
|
admin
1635 Posts |
Posted - 09/05/2017 : 09:54:25
|
 |
|
|
|
jasonp
South Africa
7 Posts |
Posted - 09/05/2017 : 11:33:40
|
Ok.. problem solved, although more work to go back and fix stuff :)
if i use the $ in the format string, it will pick up the locale when using excel to connect to the cube.. but doesn't seem to work well with the reportportal.
If change the format string to be specific about the R instead of $ then its fine, seems i need to use \R #,## etc... the backslash seems key.
Tested in ReportPortal Server - looks good.. thanks for the input guys. |
|
|
| |
Topic |
|
Report Portal
OLAP Current
