| T O P I C R E V I E W |
| HLEBOEUF |
Posted - 05/16/2013 : 04:25:23
Hello,
We are evaluating ReportPortal ans a small problem we are encountering is that in a OlapReport the formating that is specified in the cubes seems to be ignored.
Is there a way to enter a formatting in The Olap Report itself.
Not just condifional formatting, more number formating ?
Kind Regards, Harry |
| 7 L A T E S T R E P L I E S (Newest First) |
| HLEBOEUF |
Posted - 05/28/2013 : 03:39:38
Ok, got this working, but .. (Yes i'm sorry) when using a scope on a measure it looses his formating.
This wat a technique i'm using described by Chriss Webb, workign superb, but not using the forat set by the BIDS
SCOPE([Measures].[Dummy]);
SCOPE([ATP PriceClass].[PriceClass].MEMBERS);
SCOPE([ATP SalesPoint].[SalesPoint].MEMBERS);
THIS = ([Measures].[ATP PP]-[Measures].[ATP_PP_All])*([Measures].[Act Tickets Pct vs All]-[Measures].[PP Tickets Pct vs All]);
END SCOPE;
END SCOPE;
END SCOPE; |
| marco |
Posted - 05/18/2013 : 04:04:55
I added a sample working Format to be displayed based on:
member [Measures].[MDX_NL_1043] as '[Measures].[Store Sales]', format = 'Currency', language=1043
See 3 samples:
http://www.reportportal.us/reportportal/Proxy.aspx?reportId=1010
Regards, Marco |
| admin |
Posted - 05/17/2013 : 22:51:58
So the problem is that a period (instead of a comma) is used as decimal separator. Please try this:
CREATE MEMBER CURRENTCUBE.[Measures].[Free Tickets Rate]
AS IIF([Measures].[Free Tickets]=0,NULL,[Measures].[Free Tickets]/[Measures].[Tickets Sold]),
FORMAT_STRING = "#.##0,00%;-#.##0,00%",
NON_EMPTY_BEHAVIOR = { [Tickets Sold] },
Language = 1036,
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'Ticket Sales' ;
Alternatively, you can set Language for all measures by using this statement after “Calculate ;”
Language(this) = 1036;
|
| HLEBOEUF |
Posted - 05/17/2013 : 06:55:20
This is my definition in the cube
CREATE MEMBER CURRENTCUBE.[Measures].[Free Tickets Rate]
AS IIF([Measures].[Free Tickets]=0,NULL,[Measures].[Free Tickets]/[Measures].[Tickets Sold]),
FORMAT_STRING = "#.##0,00%;-#.##0,00%",
NON_EMPTY_BEHAVIOR = { [Tickets Sold] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'Ticket Sales' ;
But when i place the member in a OLAP Report i'm getting
3.89140% |
| admin |
Posted - 05/17/2013 : 04:10:33
Is the calculated member defined in the application or on the server?
Can you please provide an example of expected and the actual formatting?
Have you tried changing the Language of the XMLA connection (via Admin > Connections)? |
| HLEBOEUF |
Posted - 05/17/2013 : 03:44:19
Ok, this works for normal measures, but obviously calcuted members with formatting are ignored ..
Or is this another setting ? |
| marco |
Posted - 05/16/2013 : 10:51:21
Hi,
You can have in Admin > Settings The culture settings of a user
You can have in Admin > Settings > OLAP The server formating on/off
Regards, Marco
|
|
|
Report Portal
