?
Solved

Decision Cube Capacity Problems.

Posted on 2005-05-16
4
Medium Priority
?
1,559 Views
Last Modified: 2012-05-05
Hi, i'm having problems creating a decision Cube in Delphi 7.  I use to have a DecisionQuery with 3 dimensions and 2 sumatories and the cube works fine- The problem is when i aggregated a fourth dimension. My DecisionQuery is somethiong like :

Select zone_no, sales_no, sku_id, period, sum(qty) qty, sum(total) value
from <table> where <Condition>
Group by zone_no, sales_no, sku_id, period
Order By zone_no, sales_no, sku_id, period

The DecisionQuery1 that was working fine was something like this :

Select  sales_no, sku_id, period, sum(qty) qty, sum(total) value
from <table> where <Condition>
Group by  sales_no, sku_id, period
Order By  sales_no, sku_id, period

        So, the only change is the first selected field in the query. The problem is that at runtime, when the programs executes the line "DecisionQuery1.Open" the program generates the cube with incomplete information it only appears the first 2 zones. I don't know if I need to have an index on the table or something like that.

    Other problem is, when the data in the result of the query is too much, the program sends an error message "DecicionCube Dimensions are exceeded. Change Dataset".

   Do you have a solution for this problem.
0
Comment
Question by:jpmonja
2 Comments
 
LVL 6

Accepted Solution

by:
Sergio_Hdez earned 500 total points
ID: 14035048
Just a note: If you "group by" then you don't need to "order by" the same fields -irt is implicit in the group by- so you can take off the las line in both SQLs. I don't know if it will make any improvement, but give it a try, sometimes small changes like this make the SQL plan to change to better.

Have you tried the EXACT SQL in a sql monitor to see if it returns information on more than 2 zones? Sometimes the simplier explanation is the one, and in your select may be only 2 zones are involved!
0
 

Author Comment

by:jpmonja
ID: 14036582
I've already done that and it doesn't work. i don't know if the table structure has something to do because the sales_no, sku_id and period are at the beginning of the table and the field zone_no is at the end of it.

   The EXACT SQL returns all the information.

Thanks
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month9 days, 12 hours left to enroll

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question