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


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

Advise on calculation of measure of Balance sheet account

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
 
I am building a cube on top of Navision. The transaction table contains all transactions since the start with Navision (1 July 2003) on General Ledger Account level. For the Balance Sheet accounts, we have imported/inserted opening balance amounts. For the calculation of a trial balance of the Profit and Loss accounts I can just SUM the transactions for the period and it gives me the result for the period. For the balance sheet however, I can only calculate the net change for the period but not the ending balance for that period. Does SSAS have some kind of function to calculation the amount since the first date entry? (in my case 1 July 2003) For the P&L for example I created a calculated measure by using the YTD function that gives me the SUM for January untill August, even if I have selected only the month of August. It would be nice if SSAS had some kind of STD (start to date) function. Or do you advise that I have SSIS insert an opening balance on 1 January for each General balance sheet account (if I would find out how to do that ;-)


View Complete Post


More Related Resource Links

Balance Sheet for Stock

  
Hi All hear is My Table and Database   tblRecycle Date Ope.Balance Curent Purchase Current Sale Closing Bal 18/03/2010 1336.35 0 0 1336.35 19/03/2010 250.7 0 0 250.7 20/03/2010 130.35 0 0 130.35 21/03/2010 208.9 0 0 208.9 22/03/2010 256.95 0 0 256.95 23/03/2010 243.4 0 0 243.4 24/03/2010 203.45 0 0 203.45 25/03/2010 270.3 0 0 270.3 26/03/2010 370.25 0 0 370.25 27/03/2010 244.95 0 0 244.95 and hear is my Query   SELECT     tPurchased.RecyclingDateIn, ISNULL(oPurchased.Quant, 0) - ISNULL(tSold.Quant, 0) AS Balance, ISNULL(cPurchased.Quant, 0) AS QuantityPurchased,                       ISNULL(cSold.Quant, 0) AS QuantitySold, (ISNULL(oPurchased.Quant, 0) + ISNULL(cPurchased.Quant, 0)) - (ISNULL(tSold.Quant, 0) + ISNULL(cSold.Quant, 0))                       AS StockInHand FROM         (SELECT     RecyclingDateIn                        FROM          tblRecyclingGoods     &

How do I avoid the calculation of the default measure at an intersection?????

  

In my cube – I have two dimensions.  (Among others.  Two pertinent to this question.)  These are Client and [User Client].  Client abstracts a business partner.  As such – it is very typical.  [User Client] is home grown and maintains permission for a particular user to see a Client. 

I have some working MDX that produces a list of Clients the user can see.  That MDX is:

 

select  nonempty

(&nb

Rollup calculated measure at aggregate measure and only apply calculation at leaf

  

Hi

I have the following calculated measure: MeasureX = MeasureA * MeasureB.

 

I only want the calculation to apply at the leaf level, then the answer should rollup automatically to higher levels.

 

So instead of Sum(MeasureA) + sum(MeasureB). I need sum(MeasureX)

 

The solutions I've found for this issue, refer to the relational engine to solve the problem: etl/dsv/calc column.

But I need it to be solved in the cube.

 

Thanks,

Jason


MCITP BI Developer 2008 - MCTS SQL Server 2005

display data into GridView from excel sheet

  
I have to display data from excel sheet into my gridview and also I need to figure out a way to store data into excel files from my web page. I am using C# 3.5, VS 2008.

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.

SqlServer - Windows Account to install Application from Gallery

  

Referring to this tutorial: http://www.asp.net/webmatrix/tutorials/download-and-install-an-asp-net-application

I selected umbraco cms and got this wizard:


I already have Standard Sql Server 2005 on my machine which I wanted to us for above DB and not SqlExpress.

I did not remember "sa" account pwd nor I use explicitly any account to connect to my Sqlserver. I use Windows Authentication account i.e implicit authentication. So I created new account and gave all rights and used it in the above wizard and was able to install the database after some struggle.

My question is: What if I want to use my Windows Account to install the database above? Why the wizard don't have any option to use Windows Integrated Authentication?

Note: I can create the DB with external user I created, just looking specifics for using Windows Authentication for above installation.


Wrong Account being used to access files - Help - No Impersonation

  

I run a simple .aspx website on a Windows Server 2008 machine.

There is NO impersonation, and System.Security.Principal.WindowsIdentity.GetCurrent().Name returns NT AUTHORITY\NETWORK SERVICE, which it the account which the application pool runs. In my web.config, I have <authentication mode="Forms">.

 

I tried to test the security of the application and server by removing file permissions to the .aspx files. I was greatly worried when the website continued to run without problem (it should not have been able to read the .aspx files).

By turning on file level auditing, I discovered that the .aspx files were being read by the machine$ account (if the machine is called Serv1, then the files would be read by the Serv1$ account, which seems to have access to all files on the local machine).

 

Is this a security breach or is this behaviour by design ?

Please can somebody assist, as I am worried.


ASP.Net account deleted. How to create it again?

  

 Hi I have created an intranet application using ASP.Net/IIS.

I normally need to web share the folder and allow full permission to ASP.Net user account.

However, I carelessly deleted this account. How to create it again ?

Pls help.... thanks.

 


delete record from excel sheet

  



Hello,

           I have write the code for deleting the data in excel sheet. but we have got the error" Deleting data in a linked table is not supported by this ISAM."

     below I paste some code snippest.

string strDelete = "Delete  from [" + strSheetName + "$]";

            cmdExcel.Connection = con;
            cmdExcel.CommandType = CommandType.Text;
            cmdExcel.CommandText = strDelete;

            cmdExcel.ExecuteNonQuery();


Please can anybody this answer.It is urgent


delete data in excel sheet

  

Hello,

           I have write the code for deleting the data in excel sheet. but we have got the error" Deleting data in a linked table is not supported by this ISAM."

     below I paste some code snippest.

string strDelete = "Delete  from [" + strSheetName + "$]";

            cmdExcel.Connection = con;
            cmdExcel.CommandType = CommandType.Text;
            cmdExcel.CommandText = strDelete;

            cmdExcel.ExecuteNonQuery();


Please can anybody this answer.It is urgent




How to read value of CheckBox in EXCEL sheet

  

I am using OLEDBConnection (@"Provider=Microsoft.ACE.OLEDB.12.0;") to connect to the EXCEL file and read contents. When I read the contents, I get all the contents from the excel sheet but i dont get contents for checkboxes placed inside.

My Excel sheet contains set of checkboxes and I need to know If they are checked or not.These checkboxes are controls which are added from Developer tab in EXCEL.

I dont want to use Excel Assemblies for reading contents as it is not recommended. And also i am using OLEDBconnection and want to stick to this .


Awaiting replies from you guys. Thanks in Advance.


Export Gridview data to Excel sheet

  

Hi ,

     I have a requirement where i need to export the gridview data to excel.My code export the data in excel that was fine.

But the enchancement needed now , I was exporting the 3 gridview in same excel sheet under the workbook.

Now i need to export the 3 grid view in 3 different sheet in the same workbook.


so can please tell or share the updated code in my below code ...

public void writeovrsummary()
    {

Response.Write("<BR>");

        Response.Write("Overall Summary");
        //Response.Write("<BR>");
        //Response.Write("Report as of " + DateTime.Now.ToString("hh:mm ss tt"));

        StringWriter sw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(sw);

        SqlCommand com = MyConnection.CreateCommand();
        com.CommandText = "useroverall_Report";
        SqlParameter[] par = new SqlParameter[1];
        par[0] = new

Export Dataset to excel sheet in a required format?

  

Hi,

I know how to export a grid view to excel.

But here i have a Dataset which consists of data like below and also it need to display in a required format like below.

pno psubno pstate pdetailid pdetails

 12    1          CA         1           cbsdjcbdjc     

12     1          CA          2        cndcnjdcjcj

12     2           VA         4          xcndwkfcgygry

13     1            AL        1           ncdcnjdcndj

My excel sheet  should like this.

pid       pstate     

 12/1      CA             &nb

CLR Inside Out: Measure Early and Often for Performance, Part 2

  

In the second of a two-part series, Vance Morrison delves into the meaning of performance measurements, explaining what the numbers mean to you.

Vance Morrison

MSDN Magazine May 2008


CLR Inside Out: Measure Early and Often for Performance, Part 1

  

In this month's column, get the inside scoop on how to build performance into your apps from the start, rather than dealing with the fallout after you deploy them.

Vance Morrison

MSDN Magazine April 2008


Excel Services: Develop A Calculation Engine For Your Apps

  

The Excel Services architecture lets users design their own algorithms and share workbooks on a server.

Vishwas Lele and Pyush Kumar

MSDN Magazine August 2007


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