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


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

How to enable caching on SSRS that using SSAS cube to bind data

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :Sql Server
 

Hi All 

 How to set Cach refersh option for a SSRS report that using SSAS cube to bind data 

when i tried to store credential in data source getting error as show below 

"Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via http or https."

 

 

Regards

Sooraj




View Complete Post


More Related Resource Links

Browse SSAS Cube Data From Your iPhone

  
Does the world want an iPhone app that allows you to connect, browse and pivot SSAS cube data?  What features would that app have?  Is there existing apps that are close?  Looking for others thoughts on this concept.  Thanks in advance!

SSRS 2008 Interface with cube data source

  

Hi All,

Need some brainstorming and your experience here. Here is a situation and would like to understand your thoughts on this.

1. We have developed some cubes using SSAS 2008 to analyse the data.

2. We had some reporting requirement in the past and we decided to use our cube as a data source for the reports and develop using SSRS 2008.

3. We have developed many reports using the SSRS.

4. Now when the reports are passed on to the end users, they are not liking the SSRS interface...like at present we cannot increase the size of the drop down box, sorting any many other things..

As you might already know the SSRS interface i

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

Default date selection in SSRS with SSAS cube as a source

  

Hi,

 

I am fairly new to SSAS and I am hoping that someone can help me with an issue I am experiencing.  I am create a SSRS report that goes against a SSAS cube.  My cube has a Date dimension with a Fiscal Year - Fiscal Quarter - Fiscal Month hierarchy.  In my report I have created filters for a From Date and a To Date, which are populated with the hierarchy of the Date dimension.

 

I need to default the filters as follows:

 

To Date = current quarter (that is the last quarter with fact data)

From Date = the To Date quarter from the previous year (e.g. if To Date quarter = Q1 2008, then From Date quarter needs to be Q1 2007)

 

I found some SSAS code that allows me to get the index of the last quarter with data, but I am stuck at this point.  I am not sure how I can translate this into a default selection for the To Date SSRS report parameter.  I also realize that there may be a better approach.

 

CREATE MEMBER CURRENTCUBE

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

How to send filter values to a PivotTable filter when using SSAS cube as data source?

  

Hi,

I have created a custom filter web part that implements IWebPartParameters. I'm able to send values from this web part to and Excel Web Access web part and get it to set a pivottable filter based on this value.

Now, I want to do the same for an Excel Pivottable that's connected to an SSAS cube. However, I can't get the parameter value to set the filter. Is there some special format that I need to send the values in to be able to set a pivottable filter for a SSAS cube?

Thanks,
Chris


show part of the Cube data in SSRS report prompts

  

Hi,

I have generated one report in SSRS 2008 report designer, and one prompt was added in it. when I am running this report, selecting the data from prompts, it shows all the Cube data for this field.

But I want only a small part from cube data, how can I make this? Thanks!

Regards.


Connie Zhu

Data caching c#.net

  

Hi Friends,

 

I have a large SQL Database in the server from which I can create a dataset of about 10000 rows. My question is about caching this data. Which type of data caching should I choose (Server side or Client side)? Which one will provide better performance?

 

Thanks in advance


Velocity: Build Better Data-Driven Apps With Distributed Caching

  

Microsoft Velocity exposes a unified, distributed memory cache for client application consumption. We show you how to add Velocity to your data-driven apps.

Aaron Dunnington

MSDN Magazine June 2009


Web Farms: Use Data Caching Techniques to Boost Performance and Ensure Synchronization

  

Performance is an important concern for any application, but becomes critical when the app is a Web Service accessed by thousands of clients simultaneously. One hardware approach to distributing Web Services requests evenly is a Web farm consisting of multiple servers. Once on a Web farm, Web Service performance can be improved by using ADO.NET DataSet objects to cache frequently accessed data, reducing round-trips to the database. Here the author describes data caching in a Web farm environment and discusses how to avoid the cross-server synchronization problems inherent in this approach.

David Burgett

MSDN Magazine December 2002


.NET Reflection: Dynamically Bind Your Data Layer to Stored Procedures and SQL Commands Using .NET M

  

One major inconvenience of using SQL stored procedures from code is having to match type information. You have to write long wrapper functions around the procedures just to expose the data types. In the .NET Framework, however, the reflection services of the System.Reflection namespace allow you to query rich metadata that describe data types. This article explains how to use reflection in .NET to end your stored procedure nightmares. The author creates four custom classes, including one that generates a SQLCommand object based on the metadata of a method. Using this library, you'll be on your way to automating the generation of stored procedures.

Atif Aziz

MSDN Magazine August 2002


Change data on gridview bind

  

Hi there,


Simple little problem. i have a gridview that shows products assigned to a customers job. They are displayed in exVAT prices. To make it easier i want to show the inc VAT prices. How can i add VAT to 1 column in this table?


Enable Go Button after entering data in all fields using javascript funtion

  

Hi friends,

My page is having one gridview with check boxes,two textboxes and one button just like this see this link now i want to enable go button whenever user has select checkbox in gridview and he needs to enter text in two textboxes. i have written onkeyup event for two textboxes to test whether user enter text in textboxes or not but i am unable to write javascript function to check whether user has selected checkbox in gridview or not to enable go button .My requiremnet is user need to enter three inputs select atleast one checkbox in gridview and he needs to enter text in two textboxes.please friends pls tell me how to write javascript function to find whether user has selected the checkbox in gridview or not


Access and Bind data wihtout using Datasource Control

  

i want to bind my gridview with a dataset with concept of caching (to minimize the database server trips). plz give me a best example to get and bind data to gridview (command line) . grid paging is also enabled so example code should be capable to rebind data at Gridview page change.  


Data Mining solution - SSRS Problem

  
I have created a Data Mining - Time Series solution and I am getting proper results from SSAS(Mining Model prediction tab) & SQL Management Studio query. However when I try to create an report using SSRS, In the field where I am expecting the predicted value, I am getting "#Error" Any suggestions as why this is happening.

Data validation for datetime parameter in SSRS

  
Hi,   I wanted to know more about validation of SSRS parameters. I have a simple report which has a parameter called startdate of DateTime datatype. The datetime parameter in SSRS takes manual input as well. So, the user can enter any junk value. I want to ensure that the input parameter is in correct format and I want to display an error msg when the format is incorrect. My report has the following VB code for validation:   Public Function Validate( ByVal startdate As String) As BooleanIf IsDate(startdate) = True Then Return TrueElse Return FalseEnd IfEnd Function   And my report has a textbox which has the expression property set to; =Code.Validate(Parameters!startdate.Value) the textbox on the report has to display if the entered date is valid or not.   But, when i enter an erroneous date, SSRS doesn't render the report and throws a generic error. This happens even before the code written for validating the parameter executes.   Also couldn't find a way to disable the manual input for the datetime parameter. Even that would solve the problem.   Another alternative was to make the startdate parameter as string, but i want the calendar control button to be provided for the user.
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