ssas - Efficiently store and retrieve price points over time ranges -

-

We are loading data from a source that has date ranges. Rates rarely vary. 

  Productive, Supplier, Category ID, Rate, Valid from, Valid 1, 2, 3, 4.0, 2014-01-01, 2014-06-30   
 This rate is 6 Valid for the month. Reporting requirement is to show the average rates for flexible deadlines on products, suppliers, categories ...  
 So I joined the rates with time dimension, resulting in such a fact table :  
  Manufacturer, Supplier, Category, Category, Date, Date1, 2, 3, 4.0, 2014-01-01 1, 2, 3, 4.0, 2014-01-02. . (This is a rate for approximately 180 rows)   
 Therefore one rate per day will be. Since the rates are sometimes legal for a year or two, I am preparing a big fact sheet about 200 million lines and growing.  
 The cube loads in two minutes and the data is about 1.5 GB (while the datament lasts up to about 20 GB). The performance of the cube query looks fine  
 I can, of course, change the granulity, for example, there are total but daily daily rates for one month, they often do not change, but not necessarily the first day of a month.  
 I just wanted to take opinions on the spread of the line of production of the ETL process. Is it a smell, what are the best ways to be done for us?  
  
 
 
 I'm not sure where the tip would be, but if the rates do not change often, So instead of just putting my strength in the table, I want to ask about relational tables.  
 I mean, if I wanted to get rates for several dates for a certain product / supplier / category, and I knew that the table was in 1000-10000, and not 100,000 to -1,000,000, I just run a CPU query for the results, instead of getting it from the cube.  
 And through the table, I mean that the table does not have every rate with the start / end dates, which is every line you have for every rate.  
 If the relational table is indexed for my query, then it should be returned very quickly.  
 Where rates will be related to other facts, for example sales, I will create one dimension instead of one fact.    "When was this sale done?"

Comments

Post a Comment

Popular posts from this blog

php - PDO bindParam() fatal error -

-
I am trying to learn PDO, now I have written this small code, but it gives me a serious error: < P> Fatal error: Call a member function at a non-object dot () ... $ con = new mysqli ("127.0.0.1", "root", "", "csvdangercheck"); $ Query = $ con- & gt; ("Id,` var1`, `var2`) values ​​(" id,: var1,: var2) ";); $ query- & gt; bypass pattern (': id', $ id); $ query- & gt; BindParam (': var1', $ VAL1); $ Query- & gt; bindParam (': var2', $ val2); $ Query-> Executed (); I Trying to use print_r ($ con-> errorInfo ()) but Fatal error: Undefined method mysqli :: errorInfo ( ) ... can someone tell me what am I missing? Flaffeh said, you have PDO Missing Mysqy, try it: $ con = new PDO ('mysql: host = 127.0.0.1; dbname = csvdangercheck', 'root', '');
Read more

logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

-
For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i
Read more

java - Why my included JSP file won't get processed correctly? -

-
I am trying to create Java web framework (and learning), and on the basis of 'Code Generator In the process of making the material view of the database in the process of development, I stumbled into a difficulty, which I do not know how to solve it. First of all, I want the following index.jsp : & lt; Body & gt; Use all pages to be created. & Lt;% @ include file = "header.jsp"% & gt; & Lt; Hours / & gt; & Lt;% @ included file = "body.jsp"%> & Lt; Hours / & gt; & Lt;% @ include file = "footer.jsp"% & gt; & Lt; / Body & gt; And, in body.jsp , I should have it like this: & lt; Jsp: include page = "$ {Application_modul}"%> Where application_modul is an attribute defined in its controller: request.setAttribute ("application_modul", "USER_ACCOUNT \\ ' View_user_account.jsp "); This file can be found properly, but the processed JSP does
Read more