SSAS: Strange filter behaviour in client

In my cube I have one Time dimension that I use for filtering my data. The way I select my check boxes in the Time dimension influences the shown data. I checked the created filter
by using SQL Server Profiler and this shows that the created filter is totally wrong!

More Related Resource Links

We are experiencing strange behaviour on a publishing facing website implemented in SharePoint 2010.

The story
We use a (default) Content Query Webpart to show related information in relation with the current page. The filter is using a field value (UserFieldValue) of the current page and filters other pages which have the same tags. The fields, on the current page
and the related pages, are taxonomy field. Everything works fine!

We published the pages, looked at the website as an anonymous user and everything was still going smoothly. We went home, slepts an hour of 6, waked up. Proudly checked our beatifull new website :). Ahhhhh, what is this.. all content query webpart with
the filters on the taxonomy field returned exactly nil.

We logged in to our website, checked if the pages where published, and well, they are... Just published them again. And everything looked fine again.... but not for long. Exactly the next day (... app pool recycle ...) the same problem ...

Logged in again to our website, logged out... problem solved.... till the next apppool recycle.

My conclusionUntil the firrst authenticated visit to the page the taxonomy filter on the content query webpart silenty fails.

I am working on ASP.NET web application where we are using javascript calendar to accept the date in textboxes. The date format is dd/mm/yyyy. The application is running in US and UK environments.

I am facing issues in US environment while storing the dates so I have added 2 keys in config file viz culture which will be either en-US or en-GB depending on the deployment location and baseCulture which will always be en-GB.

In the code, I have added a condition which checks if culture and baseCulture values are not matching then do the conversion of date in US format.

But I have found that the code converts the date from dd/mm/yyyy to mm/dd/yyyy when the key is baseCulture (en-GB) and it throws FormatException when key is culture (en-US).

I am bit confused by this behaviour. Is this normal? Can any one please explain more about this? Note: I am working on a machine which has en-US as language and culture

// This line works and converts the date from 26/08/2010 to 08/26/2010
// Here the baseCulture is en-GB.
DateTime dt = DateTime.Parse(txtCurrentDate,baseCulture)
// This line throws FormatException. culture

Today is a day where nothing seems to work out as expected.I'm currently making the HTML and Javascript templates for our new Corporate Page.The thing works as expected in Firefox, Opera, Chrome and IE 6, but not in IE 7 and 8!The "thing" is a menu/submenu written by me in javascript.The way it looks in Firefox etc:The way it looks in IE 7 and 8:There is absolutely no explanation for the strange "rounded" edge on the right and the gradient going over it.The background is a semi-transparent optimized PNG without color profiles which shows up gray in IE 6 and transparent in the other browsers - as expected.On my other developer's computer, it shows up perfectly in both IE 7 and 8.What could possibly create this behaviour?----source:<div class="subMenusContainer">
<div class="subMenu" id="aboutUsMenu">
<a href="/Home/AboutAurora">About AURORA</a>
<a href="/Home/AboutErichKrammer">Erich Krammer</a>
<a href="/Home/AboutFoundation">AURORA Foundation</a>
<a href="/Home/AboutPartners">Partners</a>
<a href="/Home/AboutCareers">Careers</a>
<a href="/Home/AboutContact">Contacts</a>
</div>
[snip]
<div class="subMenu&q

Hi,
I have a problem with a query. The situation is a bit complicated but I'll try to explain it the best I can.
Short story:
I have a .NET application that executes a recursive query (using CTE) and then uses a DataReader to read each row's each field one-by-one using the GetValue() method. With specific parameters this query behaves quite fast but with other parameters it can take
more than a second to read a row's field (instead of the usual ~0.00001 second).
Long story:
The database:
I have 4 tables with the following columns:
1. Entity table: Id (int), Version (bigint), InternalName (nvarchar(255)), ExternalName (nvarchar(255)), Description (nvarchar(2,000)).
2. Relation table: Id (int), Version (bigint), EffectiveStartTime (datetime), EffectiveEndTime (datetime), ParentEntityId (int), ChildEntityId (int), Ordinal (int).
3. Property table: Id (int), Version (bigint), InternalName (nvarchar(255)), ExternalName (nvarchar(255), Description (nvarchar(2,000)).
4. EntityProperty table with 10,000 rows: Id (int), Version (bigint), EffectiveStartTime (datetime), EffectiveEndTime (datetime), EntityId (int), PropertyId (int).
The Entity table has 100,000 rows, the Relation table has 100,000 rows (each entity has a relation), Property table has 22 rows and the EntityProperty table has 2,010,000 rows (properties with Id from 1 to 20 are assigned to all entities and properties with

Hi,
I have a problem with a query. The situation is a bit complicated but I'll try to explain it the best I can.
Short story:
I have a .NET application that executes a recursive query (using CTE) and then uses a DataReader to read each row's each field one-by-one using the GetValue() method. With specific parameters this query behaves quite fast but with other parameters it can take
more than a second to read a row's field (instead of the usual ~0.00001 second).
Long story:
The database:
I have 4 tables with the following columns:
1. Entity table: Id (int), Version (bigint), InternalName (nvarchar(255)), ExternalName (nvarchar(255)), Description (nvarchar(2,000)).
2. Relation table: Id (int), Version (bigint), EffectiveStartTime (datetime), EffectiveEndTime (datetime), ParentEntityId (int), ChildEntityId (int), Ordinal (int).
3. Property table: Id (int), Version (bigint), InternalName (nvarchar(255)), ExternalName (nvarchar(255), Description (nvarchar(2,000)).
4. EntityProperty table with 10,000 rows: Id (int), Version (bigint), EffectiveStartTime (datetime), EffectiveEndTime (datetime), EntityId (int), PropertyId (int).
The Entity table has 100,000 rows, the Relation table has 100,000 rows (each entity has a relation), Property table has 22 rows and the EntityProperty table has 2,010,000 rows (properties with Id from 1 to 20 are assigned to all entities and properties with

I was wondering what the most popular/best SSAS client is used in the work environment for reporting? I Know Excel has limited abilities, and i was wondering what better options are out there that support drillthrough, KPI's etc.

I'm trying to debug
an application which generates a fixed number of questions from a
database of 20 questions, and validate them on button click. On
postback, I want the incorrect questions to be labeled red. However, all
the questions are labeled red on postback. I'm almost positive that the
problem is with "page_init" and "page_load", I'm using session
variables to keep track of the question IDs and invalid questions. Any
help is appreciated.

Here is the sample code.

Protected Sub Page_Init(ByVal s As Object, ByVal e As EventArgs)
dim i as integer
if Not Page.IsPostBack then
// generates a random integer array for loading the questions
For i = 0 To 1 // I'm only loading two questions
extract_question(selected_array(i))
Next
else
//extract_question queries the database and load the controls dynamically
extract_question(CInt(session("check_0")))
extract_question(CInt(session("check_1")))
end if
end if
End Sub
Protected Sub Page_Load(ByVal s As Object, ByVal e As EventArgs)
If page.IsPostBack then
dim textlabel as string
dim sessionvar as string
dim sessionc

I have trying to write a HttpHandler to Filter some content before rendering. As HttpApplication.Context.Response.OutputStream does not support manipulatiing at this stage. so, for remedy i am extending it to customize Write method

I've build a cube in BIDS 2008 on Windows 7 machine connecting to oracle data source. I've 32-bit oracle client on my machine. I'm able to create the data source, data source view, cube successfully. I can also explore the data in data source view. But when
I try to deploy the cube on my SSAS 2008 server, it fails with the following error:

Errors in the high-level relational engine. The following exception occurred while the managed IDbConnection interface was being used: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running
in 64 bit mode with the 32 bit Oracle client components installed.;An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B).

Errors in the high-level relational engine. A connection could not be made

to the data source with the DataSourceID of '', Name of ''.

Errors in the OLAP storage engine: An error occurred while the dimension,

I noticed this while i was working on asp.net dynamic data web app. It made me go crazy as I struggled quite a lot of time why this error was coming.

Basically, I have some of the custom page templates added to my application. I observed that if I keep these custom pages say /DynamicData/CustomPages/Employees/Details.aspx opened in the designer, I always get following error when i try to run the app.

Server Error in '/' Application.

The resource cannot be found.

Description:
HTTP 404. The resource you are looking for (or one of its dependencies)
could have been removed, had its name changed, or is temporarily unavailable.
Please review the following URL and make sure that it is spelled correctly.

Requested URL:
/DynamicData/CustomPages/Employees/Details.aspx

I did not understand the logic behind this. In order to confirm, i created a simple web app with dynamic data and still this error occurs. In fact, the same error also occurs if you keep any of the default page templates opened in your designer.

I am facing strange issue with Modalpopupextender when used with IE 8. My client is upgrading IE 6 to IE 8 and I am seeing some compatibility issue where the modal popup shifts the background screen to the bottom and to show the processing message. I can still see the background screen upon scrolling down and the screen is still enabled for user acxtion.

This same pience of code is working properly in IE 6 where the modal poupup opens on top of the background screen covering the complete background with gray color whicd restricts user for doing any kind of action until the processing completes.