It is always possible to create really amazing reports using just SSRS and TSQL.

So to start off with I would recommend u Forget MDX and C.

You can always move...

You would need to return the data as the output of a sp , as the data set will only return the results from the first statement.

I guess this is...

Hi Guys

The steps mentioned above have already been put into place or are not applicable to the scenario we are facing ,

partitioning of the cube along a month...

Hi Ellis

I tired Process FULL as Well as Update , and in either case the Data gets refreshed, I came to the conclusion that the way it works is...

Looks like the report execution is timing out before it can export the data into excel.

check the Report Execution Timeout in sit setting on the reports url

jay

Yes , we will be implementing a horizontal partition on the main tables , with a partition for each month.

regarding the indexes , we will be loading data once...

I think you can set colors to the parameters , I havent tried this out, but you should probably try using an expression like below in the available values option...

Hi ,

Fixed the issue 🙂 , the trailing space was in fact a carriage return , ascci value (13) , used a replace(queryphrase,char(13),'') to fix the issue .

Guess where i...

u might want to check the parameter datatype in report parameters screen, chances are the parameter has string as the datatype and ur passing a datetime value.

Are u adding a new dimension or an attribute to an exisiting dimension.

if ur adding a new dimension u need to go with process full.

As a thumb rule i would...

not sure what u mean by alarming , but u might want to check the filegrowth setting of the database , we had an issue where the file growth was...

Are u connecting using the server name or the IP , if ur using nat address then using the IP might not work until you add the entry to the...

In 2005 the schema is sepearted from users so might need to run sp_change_users_login other thats the only thing i can think off

I am not an expert at this but i think if your using seperate textbox's for differnet types of input , e.g one for Bar code, another for product name...

We have something similar implemented where the database integrity is not being maintained by relationships between tables , instead they have decided to use triggers to try and address some...