.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Asad Ali
Fauzul Azmi
Post New Web Links

MDX Root()-function: different results in Cube Browser and Excel

Posted By:      Posted Date: October 26, 2010    Points: 0   Category :Sql Server
 

I try to write a calculated member that returns the percentage of total (but independent from the chosen dimensions). So i started with the included template "Percentage of total".

When i use the measure in my cube browser, it works so far, but not when i use the measure in excel client.

The problem is the root-function. When i place my dimension in the rows-section and deselect some members in the filter-window, the root-function isn't influenced by the filter in excel. When i browse the cube in SSMS it gives the correct result, because the filter is applied to it.

You can reconstruct the problem very easily by adding this measure: "Root([Dimension Name]),[Measures].[Measure Name]"

This is a big problem in my case, because i absolutely need a grand total, that uses the filter-selections.

I already spent days to find a way, how to write e calculated measure, that just gives me the grand total according to the filter and which i can use with different dimensions. Or is there any way to access the calculated grand total cell in MDX? I can't believe that my problem is so difficult to solve.

Please help me out!

Thanks




View Complete Post


More Related Resource Links

displaying xsl results in browser

  

Hi guys,


How can I test what my xsl spits out in the browser, rather than just viewing the xsl itself?


thanks


Excel file not showing in search results

  
We have a strange issue. I have one Excel document (or at least one that I am aware of) that will not show up in search results for content within the document. I can find the document by title just fine, but when I search for words within the document I do not see it. The document was originally a 2003 Excel document and was recently converted to 2007. Other than that there isn't really anything unusual about it (some formatting stuff, but mainly just background colors and whatnot, nothing fancy). The crawl log shows the document was crawled without error. Anyone know anything else I can check on?

MSAS 2005 vs 2008 - different results of an UPDATE CUBE instruction

  
Hi ALL!   When moving from SSAS2005 to SSAS2008 I have a problem with write enabled cubes. On SSAS2005 UPDATE CUBE instruction occures almost instantaneously but on SSAS 2008 this takes few seconds. I created a cube with one dimension and one measure for testing. No aggregations, fact table initially empty, measure has 3 elements. Profiler shows that SSAS2008 UPDATE CUBE instruction initiates cube processing, but SSAS2005 doesn’t do this. What's wrong? Please, help! SSAS2005 Profiler: http://savepic.ru/1593644.jpg SSAS2008 Profiler: http://savepic.ru/1584428.jpg   Thnx!

Excel Services XLSX shows different results when accessed via Sharepoint UX vs REST

  
I have an Excel services report that connects to Project Server 2010 data via an ODC.  Looks great when I view the XLSX through the browser via the Sharepoint doc library; everything refreshes, no warnings, all is good.    But when I access this same file via the Excel Services REST call: https://myserver/_vti_bin/ExcelRest.aspx/ProjectBICenter/My%20Reports/Initiative%20Status%20Report.xlsx/model/PivotTables('InitiativeStatusSummary')?$format=html I get an older version of the report -- not refreshed with the latest data.   I have the file set to "refresh data when opening the file" in the data connectioon properties.     What am I missing?

SharPoint 2010 : Open word and excel documents within Browser without installing office Web App on S

  
guys, SharePoint 2010 how can i have the word documents and excel sheets open up with in the browse windows without installing Office Web App on the server, all i want to give users is the read access. Also i did not install anyting on sharepoint server to have pdf open up in the browser and yet it does. thanks in advance. sameer   thanks sameer

How to change connection string of a pivot table pointing to SSAS 2005 cube using excel 2003?

  
Hi All,I am not sure if I should have posted this query to Excel 2003 forum. But posting it here as it applies to SSAS 2005 as well.Ok, let me give the background before I tell the actual problem.We have users on ABC domain and the SSAS server is also on ABC domain. Users on this domain can acess the excel pivots by connecting to cube to browse the data. They leave the Userid & password field blank while they setup the connection string and it works fine. Thanks to windows authentication that takes the credentials of user logged in. Let's say I have two users A and B, they login to ABC domain with their own windows ids.  Now when user A creates a excel file having a cube pivot and then sends this file to user B, user B can refresh and modify the same excel file (he can select new measures to pivot, new hierarchies in filters and so on).Now, let's say I have another user, user C. He has excel 2003 installed on his PC and cannot migrate to excel 2007. He is on different domain XYZ but have a valid windows userid on domain ABC. The domain ABC & XYZ can not be setup to have trusted relationship. Now, when user A sends the same excel file to user C. When user C opens the file and try to refresh it or try to modify the pivot by selecting/deselecting any elements, he gets below error prompt:" An error was encountered in the transport layer." and "Errors in the

How to open a word document,excel sheet in web browser?

  
I want to upload a word document and excel document and then i want to view that document on the browser itself using asp.net and c#. How i can do this. Please send me proper code and explanation if possible.

Excel problems to browse the Cube.

  
Hi,    I have a cube and i'm facing problems with to access the SSAS 2008 cube from Excel 2003.  Initially i tried to access from one machine (Windows XP & Excel 2003)  it worked. When i try to access from another machine (Windows 7 & Excel 2003) i'm getting the below error message. Excel Was unable to get necessary information about this cube. The cube might have benn reorganized or changed on the server. Contact the OLAP cube administrator and, if necessary, set up a new data source to connect to the cube. Please help me.

Why sum function work fine in infopath and not in web browser

  
Hi,   I used the sum function in infopath, it work fine in infopath client, but the same open in web browser it not working correctly, it show the double the value. why it happen?

Excel 2007 connectivity to SSAS 2005 cube

  
Hello - I am using an excel 2007 odc file to connect to an analysis services 2005 cube (on windows server 2003 R2 OS). I receive the following error message   "Excel was unable to get necessary information about this cube. The cube might have been reorganized or changed on the server" Have already attempted the following fixes but running out of ideas now 1. Added localeIdentifier to ODC file    <odc:ConnectionString>Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=True;Data Source=bisql;Initial Catalog=SLAM ACT BUD; LocaleIdentifier = 1033 </odc:ConnectionString> 2. Ensured that all dimensional attributes which are used in MDX calculations (named sets, calculated members) are set to "AttributeHierarchyEnabled  = True" Running out of steam so any help is greatly appreciated.

Range or List Filtering via SSAS cube in Excel 2007

  
Hi All, A client has posed an interesting question, as current users of business objects webi they can filter the results of a cube/universe by copy and pasting a range or list of values seperated by a ';' into a list filter that is availble. e.g. product2;product533,;product029;product8389 etc etc. The list can sometimes be hundreds long. How is that same function acheived in browsing a ssas cube in excel 2007, all I can see is that a user has to use the drop down list and individualy select the values they want. This does not seem like a great method! Any ideas? They are using SQL / SSAS/ SSIS/ SSRS 2008 R2 Cheers DC

Can not see a cube in Excel 2010

  
Hi All, I've deployed my cube through BIDS 2008 to the test server with a user role (Read only) successfully. I can browse the cube through BIDS as well as through SSMS. However, when I try to access the cube through Excel 2010 - I'm not even able to see it. [Under the data tab, use other connection - SSAS connection - Server Name - Database name but no cube]. I've read most of the forums here related to this issue but not able to find a solution. Any suggestion?   Thanks, P

Internal server error exception on search results page when no language is set in browser

  
We have some users who receive an internal server error exception when they enter a search query on our SPS 2010 site. The SharePoint log shows the following: Internal server error exception: System.ArgumentNullException: Value cannot be null.  Parameter name: The property RequestedLanguage cant not set to NULL     at Microsoft.Office.Server.Search.Query.Location.set_RequestedLanguage(CultureInfo value)     at Microsoft.Office.Server.Search.WebControls.CoreResultsDatasourceView.CreateLocationList()     at Microsoft.Office.Server.Search.WebControls.CoreResultsDatasourceView.SetPropertiesOnQdra()     at Microsoft.Office.Server.Search.WebControls.SearchResultsBaseWebPart.EnsureWebpartReady() System.ArgumentNullException: Value cannot be null.  Parameter name: The property RequestedLanguage cant not set to NULL     at Microsoft.Office.Server.Search.Query.Location.set_RequestedLanguage(CultureInfo value)     at Microsoft.Office.Server.Search.WebControls.CoreResultsDatasourceView.CreateLocationList()     at Microsoft.Office.Server.Search.WebControls.CoreResultsDatasourceView.SetPropertiesOnQdra()     at Microsoft.Office.Server.Search.WebControls.SearchResultsBaseWebPart.EnsureWebpartReady() After some more diggin

Excel pivot table report filter selections from a cube

  
There are two filters added to the report filter, Date (8/31/2010) and Product (Product A), from a cube I have.  Everything works just fine.  Once the cube is refreshed each day to include the new data, for some reason, only the selection of Date, 8/31/2010, stays but the selection of Product changes to All Products.  Both dimensions are fully processed but the surrogate keys for existing records do not change.  I checked the MDX captured in Profiler and in the where clause, the date selection is passed from the pivot table but the product selection is lost and all products is passed in.  Any thoughts? TIA. 

about using excel sheet to acces a cube?

  
how to access an ssas cube using excel? any information about pivot table in excel, please provide

Key Dimension attribute not visible in cube browser

  
When browsing the cube either through managemnet studio the key dimension attribute is not visible . However when I browse just the dimension, I'm able to see this attribute. Is this the default behaviour ?. Is there any property I need to set to make it visble ?. The AttributeHierarchyVisible property is already set to true.

Excel Services, Kerberos, and cube access

  

Hello Sharepoint experts:

I'm testing our recently set up Kerberos with Sharepoint, Excel Services, and some SSAS Cubes.

I create an Excel Pivot table using a Trusted Connection to a cube, the "Refresh Data when opening file" is checked. The file is published to a Trusted Excel Services location in Sharepoint. I then create a Dashboard and add an Excel Web Part to display that pivot table. All works fine on my machine. When I get another user (one who does NOT have access to this cube) to go to the Dashboard page, that user can see all the data in the Pivot table.

If I then DELETE the cube that the Pivot table is based on, when the user (who never had access to it in the first place) goes to the Dashboard page, they get an error stating that the source may be unreachable or that access may be denied. This error is expected. But what I DON'T expect is to NOT receive an error the first time

Seems that even if the user does NOT have access to the cube, Excel Services still lets them see the 'last saved version of the file' even though it is supposed to query the database for new results every time.

AND when I restore the cube WITH CHANGES, that user can then not only see the pivot table again, they can see the recent changes, even though the original file in Trusted Excel Services Locations was never updated.

Is it possi

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend