| |
|
DynamiCube Support
Started by dlago at 03-22-2011 6:45 AM. Topic has 2 replies.
  
|
|
Sort Posts:
|
|
|
|
 03-22-2011, 6:45 AM
|
dlago
Joined on 03-22-2011
Posts 2
|
DynamiCube2.0 Reload data
|
|
|
|
|
Hi forum and sorry for my english.
I have a problem when reloading cubes data. I load the cubes with an initial filter. Then, the user can save this data with the dimensions structure. For example, data from the year 2010. If the user want to load data prior to 2010, then it must set the dimensions again. I need to save only the structure, regardless of the data. Is it possible?
So far, I put the SQL statement in the "DCRecordSource" and I reload the structure manually. It is work fine, the problem is that when I save only the structure, the data and dimensions don´t match, such as not properly order the fields SQL and the dimensions, but the order is the correct. Any idea?
Thanks...
|
|
|
|
|
Report
|
|
|
|
|
03-23-2011, 4:42 AM
|
Andrey - DD
Joined on 08-01-2007
Russia, Novosibirsk
Posts 671
|
Re: DynamiCube2.0 Reload data
|
|
|
|
|
|
dlago,If you want to save cube without data then you can use DynamiCube's .Save method with with SOLayout aor SOCompressedLayout parameter. Please note that in order to load this saved cube you need connection to datasource. If this wouldn't help can you please attach a small sample and steps to reproduce the issue?
Thank you,
Andrey T.
|
|
|
|
|
Report
|
|
|
|
|
03-23-2011, 8:58 AM
|
dlago
Joined on 03-22-2011
Posts 2
|
Re: DynamiCube2.0 Reload data
|
|
|
|
|
|
Thanks for your answer Andrey,
I solved the problem by other way. It is some complex because the code is not clear, it was wrote by other programmer time ago. I load the structure manually and the SQL statement in the "DCRecordSource". I saw that it work only the first time. The next time, the dimensions and its data don´t match. For the time being this can work.
Unfortunately, The solution of the "Save" method not enough for me. I save the structure in a database that can be load by any user in the network, and not all the users can access to the .cub file.
Thanks anyway...
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » DynamiCube Supp... » DynamiCube2.0 Reload data
|
|
|
|
|