Welcome :Guest
Congratulations!!!

Top 5 Contributors of the Month
ffttt

### Problem with calculation in combination with crossjoin

Hi fellows   I dont know how to rewrite my MDX in order to get the correct result.    The following MDX statement is reduced to a minimum in order to explain my problem: WITH    MEMBER [Article].[Article].[Article_CE]    AS AGGREGATE ([Article].[Article].[Article_1], [Customer].[Customer].[Unknown], [Location].[Location].[USA])              SELECT       {[Measures].[SalesNet]       ,[Measures].[Budget] } ON COLUMNS ,       NON EMPTY         [Customer].[Customer].[Customer].members         * {[Article].[Article].[Article].members          ,[Article].[Article].[Article_CE]} ON ROWS FROM SALES   If i dont display the customer hierarchie " [Customer].[Customer].[Customer].members " on rows, then every thing works fine! As Soon as I add the above customer hierarchie to my mdx statment, then every thin works fine except for my member " [Article].[Article].[Article_CE]". Instead of showing only one row for customer "Unknown" (see Member definition), a row appears for each customer and with the same SalesNet and Budget.   Any Idea how to rewrite my mdx ?   best regards Pellito

### Performancepoint Scorecard KPI Calculation problem

Hi, i want to calculate the profit in percent from a P/L statement Dimension. i use the following calculation: CREATE MEMBER CURRENTCUBE.[Measures].[CompanyEarnings] AS (     sum( setIncome, [Saldo] )+     sum( setCosts, [Saldo] )   ) / sum( setIncome, [Saldo] ) The Performance-Point Scorecard is Filtered by a Year-Month Hierarchy filter with the following Formular: ([Time].[Year - Month].[Month].&[2010-01-01T00:00:00]):<<UniqueName>> This Formular works fine for the Months, but the sum for the  Year is not calculating on only the selected months, its calculating on the hole year income and costs. If i use a filter on a set with the same months which i hoped was selected with the Scorecard-Filter, it worked fine. Here is the filter which worked, but is not dynamic: SET CURRENTCUBE.[setMonths] AS { [Time].[Month].&[2010-01-01T00:00:00], [Time].[Month].&[2010-02-01T00:00:00], [Time].[Month].&[2010-03-01T00:00:00], [Time].[Month].&[2010-04-01T00:00:00], [Time].[Month].&[2010-05-01T00:00:00], [Time].[Month].&[2010-06-01T00:00:00], [Time].[Month].&[2010-07-01T00:00:00] }; If i change the function that it use this filter all calculations seems to be fine: CREATE MEMBER CURRENTCUBE.[Measures].[CompanyEarnings] AS (     sum( setIncome, [Saldo] )+     sum( setCos

### Simple Calculation problem

Hi,

I am doing a very simple calculation that is not giving me the correct calculation and I don't know why. Here is my code:

```float abc;
abc = 0;

for (int a = 0; a < 1184; a++)
{
abc = (a + 1) / 1184 * 100; // This is percentage of loop completed
}

```

But as this loop loops through, the value for abc is zero the entire time. I've tried using different variable types for abc (i.e. int, float, double) but it makes no difference.

When running this code:

```for (int a = 0; a < 1184; a++)
{
abc = (a + 1) * 100; // This is percentage of loop completed
}
```

the values appear as they should: 100, 200, 300, 400, ect

Why when dividing by 1184 the values automatically become zero?

### BI KPI Calculation Problem

KPI calulates target and actual difference using the the following formula Actual-Target/Target. But this is not working with numbers in percentage.  For instance, Actual 2.4% and Target 2%, you will get 2.4%-2% / 2% = 20%.  Is there a formula for numbers in percentage?  It should be 2.4%-2% = 0.4% difference.

### Problem to group radio button across gridview rows

In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:

### Regrading Sharpoint 2010 problem and solutions

http://emanonsolutions.blogspot.com/
We can write your question and problem on this blogger.you get ans.use.

### This sharpoint 2010 problem solving threads

Hi friend,

you can use this thread to solving problem and solutions.

### AGE CALCULATION IN YEARS AND MONTHS

How to calculate childs age,but when i enter childs age as '03/27/2007' it returns 3 years where as actual age is 2 yr 11 months

### calculation, field and map traverse adjustment, and coordinate transformation

Free Pocket PC land surveying software -- COGO calculation, field and map traverse adjustment, and coordinate transformation -- for students and professionals.

### Virtual Path Problem

I get the following error on last line below (working on remote host): 'E:\web\sfcascom\ls_admin/uploads/images/001.JPG' is not a valid virtual path,

Note that the slashes go in different directions

I've tried a number of things but nothing seems to work. Thanks-

```Imports System.Drawing
Imports System.Drawing.Drawing2D
Imports System.Drawing.Imaging
Imports System.Web.UI.WebControls

Imports System.Drawing.Imaging.ImageCodecInfo
Inherits System.Web.UI.Page
Private Sub btnUpload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpload.Click
' Initialize variables
Dim sSavePath As String
Dim sThumbExtension As String
Dim intThumbWidth As Integer
Dim intThumbHeight As Integer
Dim sFilename As String = ""
' Set constant values
'sSavePath = "images/"

sThumbExtension = "_thumb"
intThumbWidth = 160
intThumbHeight = 120

' If file field isn?t empty
' Check file size (mustn?t be 0)
Dim myFile As Http```

I'm working project it's live on shared hosting

we'er uploading photos to a file on the server everything works fine the photo is resized renamed and sent to the folder

the upload page returns the thumbnail and the full size photo it's there all the photos have to be approved by an admin

twice now after they have been approved they disapear I checked the folder they are not there could there be anywhere

on the server they could get hung up before they go into the folder I have it setup so when you delete the data base entry it deletes the photo from the folder othe than that you need to open the folder and delete the photo this has hapened twice now I tried to recreate it with no luck

### ASP.Net Caching problem ??

I'm having a problem with an asp.net 3.0 application using a gridview to display data.  The problem seems to be that despite a brand new .selectCommand being sent to the sqlDataSource, the gridview starts displaying data from *someone else's* query.  For example, user A is logged in and will be working fine until a few page submissions later when the gridview data starts suddenly showing information that belongs to another user.

This is my first asp.net application, though I've been working with classic asp and ADO for years so I'm used to sending a SQL string and getting back the results from that string.  Apparently there is a complex caching system which is interferring which I do not at all understand so at this point I just want to stop the server from caching any data whatsoever.  Is this possible?

Any and all help will be much appreciated!!

### Could some one tell me whats the Problem with this String Manipulation ??? C#.net

Hi.,

I store some values from code behind to a label which is Hidden !

<asp:Label ID="lbl_Hidden" runat="server" Visible = "false"></asp:Label>

and at the page load event i retrieve the value of the label & assign it to a string !

stringvalue = lbl_Hidden.Text;

Now i dont know why this manipulation does'nt work !

I've a character 'A' in the string and i'm unable to replace it with a space !

stringvalue.Replace(A, " ");

Wot do u think abt it ????

### RaiseEvent problem

I have a parent page ProdView.aspx and two static UserControls, UC1 and UC2. Each UC is in an Ajax accordion pane and the accordion inside an updatepanel.

UC1 has a Gridview footer with couple of textboxes and a link button that fires an Add Row insert procedure. I want to Raise an event that will rebind the UC2 after the row insert in UC1.

First I created the sub delegate and event in UC1:

• Public Delegate Sub MyRefresh(ByVal sender As Object, ByVal e As CommandEventArgs)
• Public Event Refresh_UC1 As MyRefresh

In the same UC1 the Insert procedure that fires the insert and RaiseEvent:

Sub PricingGrid_Insert(ByVal sender As System.Object, ByVal e As EventArgs)
Dim myConn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("LocalSqlServer").ConnectionString)
Dim myCom As SqlCommand = New SqlCommand("AddRow", myConn)
myCom.CommandType = CommandType.StoredProcedure

Try
myConn.Open()
&nb

### Gridview Enable Selection Problem

Hi,

I have a gridview with Enable selection and Enable Paging equals to TRUE.

I also set the PageSize of my gridview to 4 so that I only displays 4 rows per page.

The problem is when I click the pager in the bottom of my gridview, my gridview is disappearing and no records appear.

Here is code behind of my gridview:

```If e.Row.RowType = DataControlRowType.DataRow Then
e.Row.Attributes("style") = "cursor:pointer"

```

### Problem making Role based Menu in MVC application

Hi,

I want to make Rolebase menu in MVC such that if user doesnot have permission for some action then that Action name shouldnot be shown in the Menu.

I have used the code in the url(http://forums.asp.net/t/1566328.aspx) in my MVC application.My application is a Discussion Forum(in MVC) same functionality as in this forum forums.asp.net

I have used Controllers for post, thread etc.In each controller there are some actions that are using [Authorize(Roles)] attribute

but this coding does not count  those Actions in Controllers having Authorize attribute according to the url http://forums.asp.net/t/1566328.aspx

In the code, Authorize attribute is applied to Controller class, but my requirement is of Applying Authorize attribute to some actions in controller so that some are available for all users and  some links are available rolewise.Now what is the solution for that?

Regards

### Problem upgrading to MVC3 - System.Web.Routing

Hi,

I'm trying to upgrade to .NET 4 and MVC 3.

When trying to compile my project, I get the error:

Error 1 The type or namespace name 'Routing' does not exist in the namespace 'System.Web' (are you missing an assembly reference?) C:\Users\spencer\Desktop\weblauncher\Common\MVCConfig.cs 4 18 Common

The type or namespace name 'Routing' does not exist in the namespace 'System.Web' (are you missing an assembly reference?)

I do have the System.Web.Routing in my references for the project.

BUT - when I try to view System.Web.Routing in the OBJECT BROWSER, nothing is inside!  The System.Web.Routing namespace is not in there - the entire thing is empty!  Could it that the dll is corrupted?  I tried to reinstall the .NET 4 and MVC 3 stuff, but its still empty!

The dll is coming from here:

C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0\System.Web.Routing.dll

and the runti

 Categories:
 ASP.Net Windows Application .NET Framework C# VB.Net ADO.Net Sql Server SharePoint Silverlight Others All