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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Accounting Periods..

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :Sql Server



imagine following structure:






So basicly, I can analyse sales by customer.

But what I want to do is analyze sales by customer accounting period.

I can't think of a way to set up such kind of relationship.

My only idea is custom calculations.


Are there any better ones?

View Complete Post

More Related Resource Links

Unable to get Lastperiods 4 periods in time hierarchy at different levels.

Hi, I am unable to get last 4 periods when the weeks are falling at two different months. Example: The calendarsales contains the following hierachy : Year, HalfYear, Quarter, Month, Week August month contains the following weeks:1033,1034,1035 July month contains the follwing weeks: 1032,1031,1030. So i am selecting the week 1035 and i need last 4 weeks till 1032. But the below qry is returning last 3 weeks 1035,1034,1033. It is unable to retrieve 1032 as it is coming under previous month of July.  Below is the mdx query i am using. **************************************** WITH     SET ORDEREDCAT AS   Order ( [Dim_Product].[ProductDefaultHierarchy].[Category]. MEMBERS ,[Measures].[Sales Units] , BDESC )     MEMBER [Measures].[SalesUnits_L_4WKBP] AS   Sum ( ( {   LastPeriods (4 ,[Dim_RetailerSalesCalendar].[CalendarSales]. CurrentMember ) } ,[Measures].[Sales Units] ) )     SELECT     NON EMPTY {[OrderedCat]} ON 1 ,{ [Measures].[SalesUnits_L_4WKBP]     } ON 0 FROM   [Aroyale] WHERE   {[Dim_Retailer].[Retailer].&[5]}* {[Dim_RetailerSalesCalendar].[CalendarSales].[week].&[1035]} ***************************** Please can any one help me on this. Regards, Srini.

Getting an SQL error when setting up Office Accounting 2009

here is the log file.... Microsoft SQL Server 2005 9.00.4035.00 ============================== OS Version      : Professional  (Build 7600) Time            : Sat Sep 18 10:50:20 2010   NYDC1 : Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS). Machine         : NYDC1 Product         : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.4035.00 Install         : Successful Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0006_NYDC1_SQLSupport_1.log -------------------------------------------------------------------------------- Machine         : NYDC1 Product         : Microsoft SQL Server Native Client Product Version : 9.00.4035.00 Install         : Successful Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0006_NYDC1_SQLNCLI_1.log ---------------------------------------------------------------------

T-SQL query, average of daily time periods over a date range



I'm building a report in Crystal Reports using a SQL command against a T-SQL 2005 telephony database.

I need to be able to run the query across a given datetime range, 6 months for example and bring back a 5 day display (Mon-Fri) with a group for every 15 minute interval in each day.

The group figures need to contain an average of the amount of calls presented for each 15 minute interval on any day across the whole datetime range, so for example the Monday 10:00 - 10:15 figure would be an average of all calls presented in every 10:00-10:15 range on each of the Mondays that fall within the datetime range.

I've got a query built now that gives total presented figures grouped by these intervals across one week but I can't figure out how to do this average function across a range.

Does anyone have any idea how I'd go about accomplishing this? I'm pretty new to SQL but keen to learn so any pointers on functions to research etc would be very much appreciated.

Thanks alot in advance, Andy.

Query for detail view across one week included below for table/fields etc...



count(DISTINCT Calls.SessionID) as Presented, min(Calls.startDateTime) as DateTime

INNER JOIN QueueDetail
ON Calls.sessionID =  Queues.sessionID
AND Calls.sessionSeqNum =  QueueDet

Range dimension - possible with Relative Time Periods?

Hi All,

I have a Date_Range dimension with members 7 days, 30 days and 90 days only.
Although all reporting needs could be well address using existing date dimension and
MDX filter or range operator I need a physical Date_Range dimension.

It seems possible to address my requirement (implementing Date_Range dimension) by Handling Relative Time Periods .
The blog post (by Chris) is rather old and I did not find updates on it or recent similar articles.

Please share your thoughts on how best to address this requirement.


Prakash Gautam

Periods to Date for a Set in MDX


Hi All,

There is a requirement to compute the number of days that have passed in a given year (on the current day) for one of our reporting purpose. The reports source Analysis services cube. The cube has a Financial Hierarchy with the following levels : Financial Year->Financial Quarter->Financial Period->Day

Following is the MDX that has a hard coded value as the day which returns the expected result.



MEMBER [Cnt] AS COUNT(PERIODSTODATE( [Time].[Financial Hierarchy].[Financial Year],[Tim

error 70347Hi all im having problems trying to install sage accounting everyime I try to install it

Hi all im having problems trying to install sage accounting everyime I try to install it I get the message the SQL server configuration checker cannot be executed due to WMI configuration on the machine error:70347 (0x112cb). Im tearing my hair out i found a batch file on the internet but this didnt work tried using the wmi diagnostic utility but didnt really have a clue what to do I am pretty ____ when it comes to the technical side of things and just need some help. any help would be greatly appreciated could I just remove the wmi and replace it or would i need to reinstall windows ?

Microsoft Accounting Professional 2009 - controlling user access on SQL Server 2005


I have MS Accounting Professional 2009 installed on Windows Small Business Server 2008 with the accounting database in SQL Server 2005

I can access the database on the server using my client installation of MS Accounting and use it as expected

When I add another user I am unable to restrict the access rights of that user by selecting a role for them and restricting their access by denying them access to certain areas or providing read-only access to certain areas

What happens when we select a user and select a role and un-tick the Administrator rights box and click ok is that the user rights are not saved without administrator rights.  When the user's rights are opened again, the Administrator box has a tick in it again.

The sequence of events is exactly as described - untick the Administrator box, click ok, then select the user in the "Manage Users" list again, click "Edit" and there's a tick in the "Administrator" box.

In every other respect, MS Accounting appears to work ok, i.e. no error messages, no crashes.

We believe that we should be able to work around this issue by manually setting user access rights directly in the SQL database, but so far we have not been able to do that.

Has anyone ever experienced anything like this, can anyone provide any help or suggestions?

Link asp.net website to accounting software




I would like to link my asp.net web application to an accounting software program. Are there any free software programs that can do this?

And how should i do it exactly? That every action i take gets imported into the software program

Analytical Accounting in Dynamics GP Version 10.0


The analytical accounting table AAG10001 has a field INTERID which records the company id. Off late we had issues with analytical accounting distributions missing on JEs posted from subledger modules.. Some of Transactions have INTERID as the company id and many does not ? I would like to know the significance of the value in this FIELD.(INTERID in the table AAG10001).

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