Analysis

Posted by: denve on 3 August 2017, 3:53 pm EST

  • Posted 3 August 2017, 3:53 pm EST

    Hi,



    1)Does your analysis product let us create and use cubes without using and having MSAS?



    2)http://www.datadynamics.com/Help/ddAnalysis/ddaWalkthroughRelational.html



    This walkthrough is not very clear.

    Could you let me know how I can create a schema for an existing database and what the query in this example is achieving whilst creating the schema.
  • Replied 3 August 2017, 3:53 pm EST

    Denve,

    Looking at the requirements, I would like to tell you that you can certainly show the aggregation of certain data using Data Dynamics Analysis. I would suggest you to take a look at the key features of Data Dynamics Analysis, which will give you an idea about the different tasks, which you can perform using it.

    In addition to this I would also suggest to check the walkthroughs which are available for Data Dynamics Analysis. This will help you in getting a better picture of how you can perform different tasks using Data Dynamics Analysis. I hope this is of some help.

    Regards,
    Sankalp
  • Replied 3 August 2017, 3:53 pm EST

    To clarify more on my first question, I ask this specifically because there is a load option at the viewer for extension ddacube.
  • Replied 3 August 2017, 3:53 pm EST

    Please ignore my second question.
  • Replied 3 August 2017, 3:53 pm EST

    Denve,

    I would like to tell you that Data Dynamics Analysis allows you to create and use cubes without using and having MSAS. The cube files can be saved by calling the SaveLocalCube method from an RdDataSource, UnboundDataSource, or XmlDataSource object. For example, you could use the following line of code to save the cube:
            rdDataSource1.SaveLocalCube(new System.IO.FileInfo("C:\\cubefile.ddacube"), DataDynamics.Analysis.DataSources.SaveLocalCubeOptions.None);

    Then to load the cube you would need to have a LocalCubeDataSource object and provide it with the path for the cube file.  Once the LocalCubeDataSource object is setup you should be able to attach it to the pivot view by setting the pivot view's datasource to the LocalCubeDataSource object.  This could be done in code by using something similar to:
                LocalCubeDataSource1.LocalCubeFile = "C:\\cubefile.ddacube";
                this.pivotView1.DataSource = LocalCubeDataSource1;
                LocalCubeDataSource1.Connect();

    Or on the web you could also use the following with a LocalCubeDataSource added to the aspx page:
                this.LocalCubeDataSource1.LocalCubeFile = "C:\\cubefile.ddacube";
                this.pivotView1.DataSourceID = this.LocalCubeDataSource1.ID;

    I hope this is of help.

    Regards,
    Sankalp
  • Replied 3 August 2017, 3:53 pm EST

    Hi Sankalp,



    Thank you for your reply.



    What we would like to achieve is show aggregations of certain data, related to the changes in the chosen time period but unrelated to the number of items in a result.



    Please find attached a file showing the concept and kindly let me know if it is possible to manage this using your analysis product.



    We can manage the attached functionality using ms analysis services but could not yet find a non-analysis services way of doing it.



    Kind Regards,

    Deniz
    2009/07/non-olap.JPG
  • Replied 3 August 2017, 3:53 pm EST

    Hi Could you provide more in depth support please? Whether we buy or not the product depends on the above functionality. The above example is not simple aggregation.

    Thanks,

    Deniz
  • Replied 3 August 2017, 3:53 pm EST

    Deniz,

    I was able to get the expected results by first creating a schema file from a sample database using the SchemaGenerator. Once the schema file created, I used the Data Dynamics Analysis Viewer to load the schema file. Later, I used the viewer to arrange the data in rows and columns as per the requirement and the result was displayed correctly.

    Are you facing any issues in creating the schema file? Do let me know if you need further assistance/clarification.

    Regards,
    Sankalp
  • Replied 3 August 2017, 3:53 pm EST

    Hi Sankalps,

    Could you tell me what sort of sql query you have used to achieve the above result?



    How do you manage to use timeavailable once per month no matter how many items are related to that room?



  • Replied 3 August 2017, 3:53 pm EST

    Deniz,

    I just used a basic SQL query “Select * from TableName” to get the data from the database and create the Schema file to test this issue. I have attached a small sample database named Sample.mdb and a schema file created using the “Rooms” table from the database. Please note that I have used this database and schema file just to display how you can use Data Dynamics Analysis.

    In addition to this, I have also attached a screen shot of the Data Dynamics Analysis Viewer showing the result, to display how the rows and columns can be arranged. You may want to create your own database, try creating a schema file out of it and arrange them in the Viewer to get appropriate results at your end. I hope this is of some help.

    Regards,
    Sankalp
    2009/07/DDASchema.zip
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels