Home > > Using FORMAT_STRING from SSAS cube - not working consistently

Using FORMAT_STRING from SSAS cube - not working consistently

Here's the deal.  
I've got an SSAS cube and I am scoping the format of the measures based on dimension members. 
Like this.
scope(( [Account].[Level 5].&[I000900000] )); 
format_string(This) = "(#,0,);#,0,";   
end scope; 
I'm then calling this format in the SSRS report using typical SSRS trickery and hacks.  
Well. When I run the report for one date (this is a GL financial cube), this works perfectly.  When I run the report for a different date, it all of a sudden doesn't work.  When I view the data in excel through a pivot table, everything is fine.
It's driving me crazy.  Has anyone else experienced something like this.
Hi Baracus,
Thank you for your question. 
I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 
Thank you for your understanding and support.
Charlie Liao
TechNet Community Support
Read the other 3 answers
Hi, Hoping someone can help. I have defined a logical model over the top of a set of SSAS cubes in a single SSAS database. This consists of a summary cube and detailed cubes that relate to individual products. I would like to have a "Product" di
My cube consists of a FactTable that has a foreign key to [DimDate], through column [DateKey]. My DateKey has dates from 20010101 to 20201231. My fact table only has data from today (20141017).  In SSRS, I add the dimension Dim Date, Date Key as para
Hi, I've got a SSRS report which use a SSAS cube as source. In the report there are 5 parameters which are build in the Report builder 3.0 using the designer.  The report server is a SQL server 2008 R2 with the latest updates. The issue that I am hav
I have a SSAS cube with a date dimension called Posting Period and now I would like to have my report parameter using this date dimension to show the current month. So far I have worked out the following expression which are working(Fiscal year calen
How to create an expression for a default SSRS parameter to a SSAS cube when using i Fiscal Year calendar - and where I want to show current Calendar month and year (for example February 2014)  This is an example of my Time dimension for February 201
Hi, Experiencing problems with with the SSAS cube once its processed. Sometimes takes around 20 mins for the excel to load once you drag down any dimension.The cube has got no calc scripts/named sets etc.It has around 17 dimensions and one dimension(
Hi I am facing a weird problem. I have 3 SSRS reports that are based on an SSAS cube. Few days back I deployed some changes to cube and everything works ok on dev environment. When I deployed the same changes to production, SSRS reports don't work. I
Hey Guys,  i m building an SSRS report using SSAS cube as the data source. The report contains shared data-sets which provide the required data. below is the set up. Sql server version : Sql server 2008R2 Report builder 3.0  I have, Report A, powered
Hello Group Members, I am facing a cache and performance issue for the first time, when I try to open a SSAS cube connection using Excel (using Data tab  -> From Other Sources --> From Analysis Services) after daily cube refresh. In end users system
Hello Group Members, This is a continuation of my earlier blog question - https://social.msdn.microsoft.com/Forums/en-US/a1e424a2-f102-4165-a597-f464cf03ebb5/cache-and-performance-issue-in-browsing-ssas-cube-using-excel-for-first-time?forum=sqlanalys
Hi, My SSAS server is having 16 Core's . I have created a power view in sharepoint site, which is accessing ssas cube. The report is taking more time to show the result.  I traced the DAX query using SQL Server profiler. When I ran this DAX query in
Good Evening, We are experiencing issues when executing an SSIS package from a SQL Server job. However, when we execute the package locally, it is successful. The package connects to an external SSAS cube using MDX. I have attached the error message
Hi, We imported Microsoft Analysis Services (SSAS) Cube into RPD using XMLA.  While using the drill down feature in BI answers using presentation hierarchies, OBIEE is generating the following error Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P Code: 10058
New to the world of SSAS cubes.  Here is my scenario... I have company A that has revenue R for a given month.  I have company B that has revenue S for the same month.  I have Company C that has revenue T for the same month.  I need to calculate the
hi, I have a requirement where I have to use existing database(OLTP) as my source to the SSAS cubes and then to build the reports. Where for Cubes and Reports I uses SQL Server BI edition. But my existing source data will be in non BI database. My qu
We are running SQL Server 2012 and Sharepoint 2013 we are having problems with Powerview modifying a calculated measure in the underlying multidimensional cube. We have a powerview report with multiple pages that allows a user to utilize a global fil
Hi All, I have one problem in my project ssas cube. one of the dimension hierarchy, a value has been set up as default member in calculation tab. The problem is: When i filter (select multiple) this defaulted value and other value in excel pivot, it
HI, I am using SSAS 2012 version to develop SSAS cube and need help on following scenario : In the BIDS designer, on the Calculations tab:  I am creating one calculated member called [% Jobs] for which I am writing MDX expression as below : '([Measur
Dear all, we're using a SSAS Cube and try to access the data by an Excel Pivot. That works fine. Furthermore, we are using the slicer feature of Excel 2010 to select the specified data. The problem is that we have a dedicated rights concept and only