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


Post New Web Links

Undocumented behavior change - SSAS 2008R2

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

Under SSAS 2005 or 2008, running the following MDX

select { StrToMember(@Date) } on 0 from [Any]

against any database results in the error:

Parser: The query contains the Date parameter, which is not declared.

which is the correct error message.

Under SSAS 2008 R2, this results in the error:

Query (1, 23) Parser: The syntax for 'Date' is incorrect.

even if the value for the @Date parameter is supplied with the query (e.g. from as SSRS dataset or any other XMLA client). Any parameter (that I've tried) with a name other than @Date behaves as expected.

This is a breaking change that's not listed (near as I can tell) in any list of changes to SSAS for 2008 R2.  In fact, the "What's new in SQL Server 2008 R2" does not admit that there were any changes in SSAS at all.

Can someone from the product team confirm that this is a breaking change in 2008R2 and whether it's just a bug, or did @Date take on some new, undocumented meaning in 2008R2?


-cd Mark t


View Complete Post


More Related Resource Links

Font didn't change in excel, after change was made on SSAS

  
Hello!   After I wrote MDX, I gave to my calculated field a format of “courier New” and font size of ‘9’. When I connected to SSAS using excel, and pulled my data but I don’t see the right format that I used. It is not working for any format. I used 2008 SSAS. What is the issue? Thx, Beney

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

Change custom activity behavior

  

Hi,

To run the workflows from XAML I use WorkflowApplication.Run. I would like to change behavior of the custom activity depends on how the activity was running. I mean - in some situations my custom activity should report to DB, but in other situation shouldn't. I can add InArgument (or property) to this activity, but I don't know how to pass to my custom activity value for this InArgument (property).

Is there any other way to do, what I described?


SSAS 2008R2 - Enable to process a database using Oracle OraOLEDB data provider

  

Hi,

I've created a data source in BIDS using provider OraOLEDB.Oracle.1. The Oracle database is 10gR2. The client installed on my computer is 10gR2. The connexion is OK when I use Test Connexion in BIDS.

In the data source view I created a very simple query: select * from user_objects. All is fine, the fields are correctly defined.

I've created a dimension based on this query with object_id as the key.

I've deployed the solution to the server. All is working fine for the moment.

But when I process the dimension I get a dozen of error messages like (sorry error messages are in french) :

"Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.Oracle.1' on line 8; 42000."

Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de dimension portant l'ID 'Test' et le nom 'Test'.

Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de l'attribut 'SUBOBJECT NAME' de la dimension 'Test' de la base de données 'CTRL_DOMAINES'.

Serveur : L'opération a été annulée.

Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.O

Regarding realtime update of SSAS cube when underlying data change

  

Hello All,

This is regarding the automatic update for SQL Server Analysis Service cube incremental update.

We have developed one cube which contains item details with several attributes.

And in our application, we have built search and to get result we are querying that cube. Now whenever new item is added or any of its details changed, we want to update the cube with changes.

I already know, that we can do it via scheduling cube processing at some small interval. But we want to have some real time optimal solution to update the cube.

If anyone has idea about any optimal method, please let me know. Its very urgent.

Thanks in advance.

 

 


Darshan Vyas

Regarding realtime update of SSAS cube when underlying data change

  

Hello All,

This is regarding the automatic update for SQL Server Analysis Service cube incremental update.

We have developed one cube which contains item details with several attributes.

And in our application, we have built search and to get result we are querying that cube. Now whenever new item is added or any of its details changed, we want to update the cube with changes.

I already know, that we can do it via scheduling cube processing at some small interval. But we want to have some real time optimal solution to update the cube.

If anyone has idea about any optimal method, please let me know. Its very urgent.

Thanks in advance.

 


Darshan Vyas

With Excel pivot table client using SSAS cube, how to change the measures to rows?

  
I want the measures as rows instead of columns in Excel pivot table on a SSAS 2008 cube. How do I do that? Thanks.

Process Update does not reflect change in case of dimension member in SSAS 2008.

  

Process Update does not reflect change in case of dimension member in SSAS 2008. We can replicated this issue in Adventure Works 2008 with below steps.

 

1.  Customer Name Aaron Allen is in Title case both in Adventure Works SQL 2008 Data Mart as well as in SSAS 2008.

 

2.  Change Customer Name Aaron Allen to Upper case in Adventure Works SQL Data Mart.

 

SSAS Time Dimension (academic years, quarters) change over time

  

Apologies if I don't state teh question properly or am overlooking obvious answers - just started working with SSAS and barely beginner level.

I'm working on a cube to show student enrollments in different subject areas over time - for this purpose I'm only concerned about academic years and semesters.  In the underlying dimension table I have data like

KEY ACAD YEAR     TERM          DESCR
1 2006          SUMMER  SUMMER 2006
2 2006          FALL  FALL 2006
3 2006          SPRING  SPRING 2007 (note that spring 2007 is part of the 2006 academic year)
4 2007          SUMMER  SUMMER 2007
5 2007          FALL  FALL 2007
6 2007          SPRING  SPRING 2008
and so on

I've set up a simple hierarchy with only two levels - ACAD YEAR->DESCR

For the cube I have one measure: 'Enrollments' which shows the sum of students who have enrolled

What I'd like to be able to do is show the f

Custom Editing Behavior for DataGridView TextBox Columns

  
For various reasons I'm using a DataGridView instead of a ListView, and while configuring the DataGridView to look like a ListView wasn't much of a problem, there's one thing that got on my nerves, which is the behavior of textbox cells in edit mode: It is much too easy to leave the edit mode accidentally, simply by pressing the cursor keys at the wrong time. For example when the text caret is positioned behind the last character of the textbox cell content, and you press the right arrow key

How to Localize Windows Forms and Change the Language at Runtime

  
Localization is the process of customizing your application to a particular language, culture or locale. Visual Studio provides support for localizing Windows Forms with much ease. In this article, we will see how to localize windows forms and give the user the ability to change to his preferred language at runtime.
When you run a localized application, the appearance is determined by two culture values. The UICulture property is used to specify which resource files will be loaded for the form. The Culture property, on the other hand, determines how strings such as dates, numerals, and currency amounts are formatted.
Let us see the steps required to create a localized form. You can then expand this example and adopt the same approach for the rest of the forms in your project

Selected to change the background color of the page

  

Hi,

As this site, http://www.borfin.com.tr/genel/Default.aspx, How can I change the background color selected pages.


Bug: Does not change column type from nvarchar to ntext

  

Scenario: If you create a table with a column of type nvarchar, populate it with some content and try to modify it using the WebMatrix editor, from nvarchar to ntext, it does not display any error message or warning that this is not possible. It silently saves and reverts the change, back to nvarchar. Wasted some hours on this issue as I thought my column was ntext, but in fact was still nvarchar.

Expected behavior: It should change to ntext, or if SQL CE doesn't support that, it should notify the user that no change was applied.


Run Button Behavior: Suggestion/Bug

  

Note: This could be a bug or considered as suggestion. I am not looking for solution.


1: I have ImageWatermark.cshtml open and currently in focus.

2: I have Photo1.jpg selected in left Files workspace.

3: Now if I Click "Run", instead of opening ImageWatermark.cshtml it trys to open Photo1.jpg and it fails.

So ideally I would expect the "open file (ImageWatermark.cshtml) to run rather than running the selection from Workspace.


How to change the default page base class?

  

I've tried setting the <pages pageBaseType="DynamicWebPage" /> value in web.config, but when I response.write out the page type, I'm still getting Microsoft.WebPages.WebPage.

I'm simply trying to sub-class WebPage and add some additional functionality such as a dynamic PageData dictionary similar to Phil Haack's dynamic ViewData dictionary.

Thanks,

Adam


SqlDataSource how to change the stored procedures at run time

  

Hi

Is it possible to change the select, insert and update stored procedure of an SqlDataSource at run time. I don't mean to change the definition of the stored procedure, but I mean to change the assignment, i.e. To change the select stored procedure from "selectSP1" to "selectSP2" at run time. Is it possible?

Regards

Dimitris


Change Button Text in Multi Language Website

  

Hi i developing multi language website

using Master pages

everything fine

Page_Load i set the Text property of Button Control from Resource file

like this

Button1.Text = GetLocalResourceObject("Button1")

then in the button click event i cnage the text of the Button control

Button1.Text = GetLocalResourceObject("Button1_new")

but the text doesn't change and no error messgae

what is the problem how to solve this

 


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