Link Report Problems

I have established a set of base reports which are then linked to a variety of department specific folders. Moreover, many of the reports have the capability to "Drill Through". The problem occurs when clicking on a Drill Through field in one of the department specfic folder -- it directs the drill through to a report in the Base folder instead of the department specific folder. Pleaseeeeee help!The behavior you are seeing is the expected behavior for linked reports. Relative paths are resolved based on the location of the source report, and not the linked report.|||Hopefully in a future release there could be an option to select either base or linked folder(s).

Limitation of # cubes inside a base Analysis Services

Does anyone

have any idea which is the limitation of # cubes inside a base Analysis Services,

because I created 50 cubes, and when I tried to connect to the base, i was

enable to do that because the CPU was at

100 %.

I think

that is a problem when analysis services tried to read the xmla and print all the cubes.

Tks

Well. There is a point where number of cubes and size of your data requre you to go and get a bigger machine.

It would be wrong to assume you can create any number of cubes and expect from Analysis Services not to use more CPU or memory trying to handle them all. The question what is reasonable. If you think that you got poweful machine with multiple processors and fast I/O and you see Analysis Services cannot handle large number of objects, there could be somehting. As a reference you can use Project REAL that handle large number of objects. http://www.microsoft.com/sql/solutions/bi/projectreal.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hallo Calacean,

the problem, you have accounted is not a SSAS with its limitations, but the client you use.

Some clients read copletely all metadata (available cubes, dimensins, hierarhies, levels, measures etc.) immediately after connection to the database.

Take a time to monitor with the SQL Profiler what commands and queries are sent from your client to the sever. You do find some interesting for you.

|||

Thanks, is

very useful, but i have another question if i don't bother you.

I have a data warehouse with 50 mil. dates. And i have 6 measures group with

relations many 2 many. When i query the cube, first is very slow( and i design aggregations

for all the measures), and second (I have proactive caching setup), when i want to

modify some data from the tables of proactive caching , the proactive caching

is working very god, but it decrease very much the performance of the server,

and the performance of the applications. I forget to mention that I have P4

2Ghz(2CPU), 2GB Memory, and I run Sql Server 2005 and Analysis Services in the

same server.

limit the number of digits after decimal point in flaot data type

Hi..

I have a column in the data base with the type Float,

I want to limit the number of digits after decimal point to 2 when I display the value in ASP.NET but I don't know how!?

the number that appear after calculation llike "93.333333"

I use decimal(2,2) as data type but an error accour and this is the message

"- Unable to modify table.
Arithmetic overflow error converting float to data type numeric.
The statement has been terminated."

Can you help me..

thanks

Hi..

Before saving to database you can use String.Format() method to modify your float value.

First you need to convert float into string using

String myStr = Convert.ToString(yourFloatHere);

And then use String.Format("{0:N}", myStr);

and then again convert it into float using COnvert.ToDouble(MyStr);

Cheers n Hope it would help

|||

Hi..

I try what you suggest but the following error produced:

Cannot implicitly convert type 'double' to 'float'. An explicit conversion exists (are you missing a cast?)

Do you konw its solution?!

This is my code:

//------------------

float temp;

String value;

SqlConnection con =newSqlConnection(@."Data Source=localhost ;Initial Catalog=university ;Integrated Security=True");

con.Open();

SqlCommand cmd =newSqlCommand("select SUM(FinalGrid)/COUNT(FinalGrid)from studentSections Where studentSection_UserID='" + Session["ID"].ToString() +"'", con);

SqlDataReader reader = cmd.ExecuteReader();

while (reader.Read())

{

value =Convert.ToString(reader[0]);

}

String.Format("{0:2}", value);temp =Convert.ToDouble(value); //Here is the error

reader.Close();

//------------------------

Is it has any wrong?!

|||

Do not use the decimal(2,2). Just have the way it is now and just modify the SQL statment that you use to retrive the data and include the function

STR(columnname, lenght, number of decimal places)

This function will automatically round the data in this column to number of decimal places u want when the data is returned to ur ASP.NET application.

|||

Hi..

Can you tell me where I should use this function? and what do you mean by "length" ?

|||

Suppose you are using the query "select column1 from table1" to get the data to your applicaiton, where column1 is the one where you want only 2 decimals

u will have to use it as "select str(column1,10,2) as column1 from table1"

this will make sure you have only 2 decimals in the data that is returned, if there are more than 2 , it will round it to 2 decimals.

|||

Thanks so much its work very nice