Hi, I don't really know how to handle facts that happened over a period of time. I sually deal with facts that happened on a specific date. In clear, my facts have a start_date and an end_date. So, let's say my start_date is 01/01/2008 and my end_date is 01/01/2011. I need to get the number of those facts that happened in 2009 and thos...
The Analysis team wants to analyze sales pipeline data. Our CRM system(Source system) send the Data Warehouse team transaction as the Product moves through the different stages. To mention a few: Creation, CallMade,LeadEngaged,CreditCheck,PapersReceived,Closed.There are more than 100 tracking statuses like mentioned above. Sample tran...
i'm using delphi 7 to run the hiercube version 4.32. When i retrieve the data, the pc memory keep increasing until occur 'Out of Memory' bug. I suspect the cache of memory did not clear when retrieve the data from hiercube, so when i retrieve data for 2nd or third times then it occur 'Out of Memory' error. Any idea to solve this 'Out of ...
Hi, We have a system that tracks the allocation of a unit of work, from receiving that unit of work till completing that unit of work. A unit of work has a number of attributes, it's source, it's type etc. These I'm fairly ok with modelling, likely to be either dimensions of the fact or just attributes depending on the nature of them a...
i'm using hiercube version 4.32 and delphi7 now. I facing a problem that when i load the saved state (eg. filter 5 stocks), it give me extra stocks (automatic filter new added stocks become 6 stocks). How can i stop this automatic filter function of hiercube saved state to avoid it automatic filter by new added item? ...
I would like to draw voxels by using opengl but it doesn't seem like it is supported. I made a cube drawing function that had 24 vertices (4 vertices per face) but it drops the frame rate when you draw 2500 cubes. I was hoping there was a better way. Ideally I would just like to send a position, edge size, and color to the graphics ca...
I need an example of what drill up/down is ( + if it's graphical ) for a better understanding of these operations. I'm new to the whole Data Warehouse subject so high level explanations would be appreciated. ...
[Before] - Filter the docType as shown below and save the state. [After] - Add new item into database (eg. stock), then load back the saved state. You will found that the filter changed as shown below: The doc type filter chaged after add new stock in database. Adding new stock will add new list in stock ID dimension but it suppose w...
I have to write a compass app in Android. The only thing the user sees on the screen is a cube with a red wall which has to point north. This is not important. What's important is that I need to rotate that cube accordingly to the rotation of the device itself so that the red wall continues to point north no matter how the phone is being...
I have a very simple MDX query that retuns the contents of a dimension. I would like to inject one more row to the result set as part of the MDX. Is this possible? ...