How To Combine OLAP Data With Relational Data
Can anyone point me in the right direction please. I have built a cube with sales data, by week, product and branch. I want to create a report which has the last 5 weeks sales, with the current stock from the main relational database. I can't seem to find any method of doing this. Am I just thick?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Approach Help To Load Data From Flatfiles Into Relational Table Where Data Is Coming As Spaces In Few Columns From Flatfiles
Hi , My Input is a flat file source and it has spaces in few columns in the data . These columns are linked to another table as a foreign key and when i try loading them in a relational structure Foreigh key violation is occuring , is there a standard method to replace these spaces . what approach should i take so that data gets loaded in a relational structure. for example Name Age Salary Address dsds 23 fghghgh Salary description level 2345 nnncncn 4 here salary is used in this example , the datatype is char in real scenario what approach should i take to load the data in with cleansing the spaces in ssis
View Replies !
View Related
OLAP Relational Structure
I am building a data warehousing solution without using analysis services or OLAP or OLTP.... Dont ask why ... but I have to.... Ok so which table structure would be better ? dimention 1|dimention 2|dimention 3|matrix 1|matrix 2|matrix 3|matrix 4.... or dimention 1|dimention 2|dimention 3|matrix name|matrix value I prefer the second one....
View Replies !
View Related
On The Subject Of Data Warehouses, Data Cubes && OLAP&….
On the subject of Data Warehouses, Data Cubes & OLAP….I would like to speak frankly about Data Warehouses, Data Cubes andOLAP (on-line analytical processing). Has it dawned on anyone elsethat these buzz words were created by some geek who decided to take astab at marketing? Knowing that to the backwoods manager who knowslittle of technology that new innovative names for old concepts wouldhelp to sale their products.I mean seriously, what is the story here? In a nut shell, and pleasestop me if you disagree, but isn’t a data warehouse simply adatabase? Can’t you do everything on a conventional databaselike SQL Server, Oracle or DB2 that you can do on these newproprietary Data Warehouse constructs? I mean who are they trying tofool?Take a look, for instance, at Data Cubes. Who hasn’t noticedthe striking similarity between data cubes and views used in all themore robust databases? Also, what about OLAP? OLAP is nothing morethan a report generator. There’s nothing you can do with thesemillion dollar price tagged Data Warehouse total solution packagesthat I can’t do with SQL Server, Oracle or DB2…for thatmatter Microsoft Access.As an example some sales people for Metadata Corporation has the VicePresident of I.T. in Nashville, for Healthspring, sold on their totalsolution data respository which is such a scam. All they had to dowas throw a couple of buzzwords at him and they have him hypnotized.Personally, I feel that these kinds of marketing practices undermineour industry. It helps to unravel what little standards orconsistency we have. What do you guys think?Stuart
View Replies !
View Related
Relational Data And RDA
I have a few questions for you guys. I have a client application that can be offline or online. While offline, records can be added and need to be later synced to production. I will use rda to pull the table down, and this is working fine. Now what if I have multiple tables where I want a foreign key relationship? With rda I can only pull down one table at a time from everything I've read. Now say create a constraint after pulling the two or more tables down. While in offline mode I create a new record on two seperate tables with foreign key/primary key relationship. When I do the push to the server will it automatically update the foreign key reference (locally) to the right one on the production server? Or will I get a duplicate primary key error? On the production server the primary key will be different because of the identity. This is very important because I will have multiple clients. Thanks in advance
View Replies !
View Related
SQLDataSource Relational Data
I am just now starting the switch from .NET 1.1 to .NET 2.0. I really like the new way of using the SQLDataSource and setting up Views declaratively as opposed to doing it all in code, which brings me to my question.In some of my applications I have a single Stored Procedure return multiple result sets to a single DataSet where I have a DataRelation set up. Then I can have nested DataGrids that use the GetChildRows() method to filter the results to display the hierarchical data. I would like to do something similar with the SQLDataSource and GridViews but haven't found a way to get multiple result sets.One thought I had was to create a Strongly Typed Dataset and then use the ObjectDataSource object, but I still didn't see a way to get child rows out of the datasource. I've seen an example that uses a <FilterParameter> to get nested data, but there is an extra trip made to the server for each parent item as it just put an extra parameter in the WHERE clause of the query.
View Replies !
View Related
Relational Data Transfer In DTS
Hi Please help for this simple problemDTS Transfer or any other method?I have Customer_Order Table and customer_Order_Details Table.For OrderID = 1, I have 3 rows of Order Details.I want to transferCustomer_Order Table for OrderID 1 in DTS, the system should transferOrder Table as well as Order details table Rows for ORderID =1.How to customize in DT or is there any way to get this data to transferfrom source DB to Dest DB?KAMAL KUMAR V--Posted via http://dbforums.com
View Replies !
View Related
Save OLAP Query Results To Relational Table
I have cubes that hold quite a few calculations and so creating Excel pivot table views from it take a long time. This is even true for Excel 2007. Now I wonder if it would be possible to write back all the calculation results to a relational table - maybe one that exactly matches the report format - so creating another report would be much faster? SSRS seems to be a way to go but it does not speed up my Excel case. I read about write-back in ROLAP and MOLAP but I don't think any of these concepts help me to really speed up my reports. The closest thing I was able to find so far, which besides seems to do exactly what I want is Microsoft's new PerformancePoint 2007. It's just it seems overkill for my projects and the price is at $20K. Any suggestions are appreciated. Dirk
View Replies !
View Related
Using A Sub Query To Return Relational Data
Hi i am trying to use this query to pull all the publications stored in the database and all the authors contributing to that publication (1 to many relationship). I am trying to use a sub query so that i can display the results on one row of a gridview (including a consecutive list of all the authors). However i am recieving this error: Incorrect keyword near the word SET. ? Maybe i need to add a temp column in the sub query to pull all the related authors for a single publication - but i dont know the sql for this? can anyone help? Thanks SELECT ISNULL(Publication.month, '')+ ' ' + ISNULL(convert(nvarchar, Publication.year), '') as SingleColumn, Publication.publicationID, Publication.title FROM Publication WHERE Publication.publicationID IN (SELECT (convert(nvarchar, Authors.authorName)) FROM Authors INNER JOIN PublicationAuthors ON Authors.authorID = PublicationAuthors.authorID) AND Publication.typeID IN (SELECT PublicationType.typeName FROM PublicationType INNER JOIN PublicationType ON Publication.typeID = PublicationType.typeID
View Replies !
View Related
Xml File Import - Relational Data
Hi, I have played around with SSIS in addition to reading an SSIS book front to back, but I am still a little confused as to how to import an Xml file with relational data. The Xml file is structured as follows: <products> <product> <name> <id> <category> <name> <id> </category> <fields> <field> <name> <value> </field> <field> <name> <value> </field> </fields> </product> </products> Basically I want to import the Xml data into three tables: categories, products and fields. A product can belong to one or more categories and has one or more fields which store information about the product. Using the Xml Source component I can load the Xml from the file, but I can only output one section (category, product or field) at a time. Since the relationship is infered from the hierarchical structure of the Xml (e.g. the fields don't store an ID of the product they belong to), I am not sure how to import the relationships into my tables. If anyone has any tips on how I can go about that, then it would be most appreciated :) Thanks!
View Replies !
View Related
Fast Loading Relational Data
I am searching for a way to fast load relation data. I know how to load data fast but how can i store relation data fast. For example : Table1 ( tabel1Id int identity , name varchar(255) ) Table2 ( tabel2Id int identity , table2Id , name varchar(255)) When i insert 50 records into Table1 i can't get the 50 identity fields back, to insert the related data into Table2. I think one of the solutions could be returning a selection of Table1 joined with syslockinfo, but i have no idea how to do it. Does anyone have an idea?
View Replies !
View Related
How To Flatten Relational Data For Analysis
Hello everyone, this is my first post here so hopefully I am not asking a common question. I am trying to create a flat dataset in SQL 2005. Basically I run a query and I get multiple rows for the same primary key. The query I am running is quite large and has several different tables connected to it, here is a small sample of what it looks like... Typeid(Primary Key) Individual Address 1 Sam 912 Ave. J 1 Sam 913 Ave. Q 1 Sam 914 Ave. R 2 Mike 1000 Ave. O 3 Jill 1001 Ave. O I want it to kind of look like this TypeID Individual Address_1 Address_2 Address_3 1 Sam 912 Ave. J 913 Ave. Q 914 Ave. R 2 Mike 1000 Ave. O 3 Jill 1001 Ave. O As I said before, this query is pretty big, and has several variables like Address where multiple rows are being taken by one Primary Key. If it is not possible to do this in SQL 2005, is there a program that may be able to? Right now we are using SPSS as sort of a bandaid... we run the query in small portions like the one in the sample and then restructure the in sections but this takes several hours. Anyways, thanks for any help that you may be able to provide. -John
View Replies !
View Related
Need To Insert Data Into 2 Tables, Relational Having Problems
Ok, I have a page on my website where we can add products to our database. We are a music store, and most products have different versions or colors. I've created 2 tables, Products and Subproducts. The products table may hold info like Fender Stratocaster, and the subproducts would hold colors (Blue, Sunburst, etc). The subproducts table has an integer field called MainProductID, which is linked to the mainproducts table field RecordID. So far the page uses a wizard where if first creates the main product using an sql datasource. After the data has been added to the main products table, my page gives you the opportunity to add different sub products. The problem I am having is actually feeding in the RecordID from the main products table to my insert parameter on the sub products data source. This is what I have tried so far: There is a formview on the page that is bound to the main products table, after the entry is created I can physically see the info on my screen, so I know the data is there at my disposal SubProductsDataSource.InsertParameters.Add("@MainProductID", Formview1.datakey.item("RecordID"))SubProductsDataSource.Insert()Using this adds the data to the table, but the MainProductID is nullalso is there a cheap little way to refresh a page, because when I upload the product images I have it go to the next step where you are supposed to be able to see the images you uploaded, I don't see them which makes me think that the page is loading faster than the images are uploading. Thanks
View Replies !
View Related
Matching Relational Records. Is It Possible Using Data Minig?
Problem: I am working on a price comparison system which matches the best prices for a purchase (or an order) from exisiting purchase data. The order is stored in multiple tables including order details (stores major items purchased: e.g., PC) and order sub-details (optional items purchased with the major items: e.g., speakers, backup device, webcam etc.). There could be a number of major items in an order and each major item could have multiple related sub items. The other variables that affect the price include trade-ins if any, sales going on at the time of order, number of units etc. Now, for any new configuration (major items/related sub items), the system should be able to return a list of previous purchases made with similar configurations, and similar variables (quatities, trade-ins etc). Even if the same model is not present, similar pcs by the same vendor should be considered. etc etc. Questions: Is this possible using Data mining? If yes, which algorithm is recommended? Also, can I assign/modify any kind of weights to certain variables (if same model: .6 ; if same model not available but pcs made by same manufacturer available: .3 ; by other manufacturers: .1)? Any help will be greatly appreciated. Thanks, Jojy
View Replies !
View Related
Create A Local Cube Using A Relational Data Source
Hi, I am trying to create a local cube populating data from a relational database like access,sql server or oracle. In the eg.. mentioned below .. i hve created an MS Access DSN. When I execute the code i am getting an error which says- Syntax error in column definition... Incase you have come across this error or have any clues as to why it may be occuring kindly let me know ... loydon11@rediffmail.com.. Thanks for sparing ur precious time. ######################################Code######## ################## Private Sub cmdClick_Click() Dim cnCube As ADODB.Connection Dim s As String Dim strProvider As String Dim strDataSource As String Dim strSourceDSN As String Dim strSourceDSNSuffix As String Dim strCreateCube As String Dim strInsertInto As String Dim strSource As String On Error GoTo Error_cmdCreateCubeFromDatabase_Click strSource = Connection(1) strCreateCube = getCreateCube() strInsertInto = getInsertInto() Set cnCube = New ADODB.Connection s = strSource & ";" & strCreateCube & ";" & strInsertInto & ";" Screen.MousePointer = vbHourglass cnCube.Open s Screen.MousePointer = vbDefault Exit Sub Error_cmdCreateCubeFromDatabase_Click: Screen.MousePointer = vbDefault MsgBox Err.Description If Err.Number <> 0 Then msg = "Error # " & Str(Err.Number) & " was generated by " _ & Err.Source & Chr(13) & Err.Description MsgBox msg, , "Error", Err.HelpFile, Err.HelpContext End If End Sub Private Function Connection(idbtype As Long) As String '''''''''''''''''''''''''Database Connection to the Cube'''''''''''''''''' strProvider = "PROVIDER=MSOLAP" strDataSource = "DATA SOURCE=c:OlapCube.cub" strSourceDSN = "SOURCE_DSN=AccessLoyd" Connection = strProvider & ";" & strDataSource & ";" & strSourceDSN End Function Private Function getCreateCube() As String ''''''''''''''''''''''''''Create cube Structure''''''''''''''''''''''''''' Dim strCreateCube As String strCreateCube = "CREATECUBE=CREATE CUBE cbia( " strCreateCube = strCreateCube & "DIMENSION[SSTORE]," strCreateCube = strCreateCube & "LEVEL[SSTORE Name]," strCreateCube = strCreateCube & "MEASURE [SSTORE Sales] " strCreateCube = strCreateCube & "Function Sum " strCreateCube = strCreateCube & "Format '#.#')" getCreateCube = strCreateCube End Function Private Function getInsertInto() As String '''''''''''''''''''''''''''Insert Clause and Select Clause''''''''''''''''' Dim strInsertInto As String '''''''''''''''''''''''''''Table name.Column Name'''''''''''''''''''''''''' strInsertInto = strInsertInto & "INSERTINTO=INSERT INTO cbia( SSTORE.[STORE Name]," strInsertInto = strInsertInto & "Measures.[STORE Sales])" strInsertInto = strInsertInto & "SELECT SSTORE.STORE_NAME AS COL1," strInsertInto = strInsertInto & "SSTORE.STORE_SALES AS COL2" strInsertInto = strInsertInto & "FROM [SSTORE]" getInsertInto = strInsertInto End Function
View Replies !
View Related
Loading XML Data Into Relational Tables From XML Datatype Column
This may seem like a redundant exercise, but in SSIS I am loading a single table with XML files into an XML Datatype column. I have already successfully loaded the file directly into relational tables using the XML Source and SQL Server destination. But during the transformations, we clean the data and if there are research questions, we have to go back to the original XML data file and search on it. I want to store this file in the database as well to facilitate easier searching. With this approach I'm hoping to accomplish a few goals: 1) Reduce the size of storage, assuming the SQL Datatype column will compress the data making it smaller than the original file. Then I can take the original file and store it offline on disk or tape. (update: Well, my assumption for goal #1 was correct. The total size of all 1,990 files was 12.6G, while the files loaded into SQL consumed 8.2G, a reduction of 35% But this isn't anywhere near the compression used by WinZip which reduced all files to < 1G which averaged around 95% compression for each file.) 2) Parse out the XML File from the table (as opposed to directly from the file) into other relational tables, hoping the speed of this operation will be equally or better performing than reading from the XML file itself. 3) Use XML Schema collections to validate the files as they are loading. So with those goals in mind, can anyone comment on my assumptions or approach to this? Also, I've bound the schema collection to the XML Datatype field, but I have multiple schemas in my collection and I can't find a property on the table that binds the specific schema to the field. Should I break my collection into 4 types (for the four types of XML files being loaded)? Also, in SSIS what will be the most efficient way to load each row (1 row = 1 data file, containing possible 1,000,000 rows of data) into a relational table? SQL XML Query? Is there a 3rd party control for this that anyone knows of? Last question: How do annotated schemas play into this scenario? Do I need to use them at some point? Thanks for any information. Kory
View Replies !
View Related
Combine Data In Single Row
SELECT * FROM dbo.empBenefits q WHERE (StartDate IN (SELECT TOP 2 STARTDATE FROM EMPBENEFITS WHERE EMPBENEFITS.employeeno = q.employeeno AND Benefitcode = 'HON' ORDER BY startdate ASC)) I have this select statement working however I need to combine 2 records in a single row in a single table. The unique key is Employee No.
View Replies !
View Related
Combine Data Into One Row, Add Columns
Hey guys, I realize I've posted something like this before, but i'm confused how to do something new, what I am trying to do is combine rows of data when certain columns equal one another. For example, I have to sets of data who have in common the columns ctp_code and a mod_code (they are the same) however they have two other columns called billing_amt and amount_owed that need to be added together (literally taking the data and doing the math, so 100.00 + 100.00 = 200.00) Code: id ctp_code mod_code billing_amt amount_owed 1 1 1 100.00 100.00 2 1 1 100.00 100.00 My results should be this: Code: id ctp_code mod_code billing_amt amount_owed 1 1 1 200.00 200.00 Any help, thoughts?
View Replies !
View Related
Getting Data And Combine Two Column
I have a table Table, there are two set of Number and store in Tel1 and Tel2 I want to get all the number of each reacod that start with '1' on each record, the number I need that may in Tel1 or Tel2, I want to get the result like 'Result' table how can I do it ? THX TableA +----+-------+-------+ | ID | Tel1 |Tel2 | +----+-------+-------+ | 1 | 12223 | 92269 | | 2 | 12269 | 97789 | | 3 | 96636 | 13369 | | 4 | 12259 | 97781 | | 5 | 92889 | 12263 | +----+-------+-------+ Result +----+-------+ | ID | Tel | +----+-------+ | 1 | 12223 | | 2 | 12269 | | 3 | 13369 | | 4 | 12259 | | 5 | 12263 | +----+-------+
View Replies !
View Related
Errors In The High-level Relational Engine. A Connection Could Not Be Made To The Data Source With The DataSourceID Of '
When I deploy the cube which is sitting on my PC (local) the following 4 errors come up: Error 1 The datasource , 'AdventureWorksDW', contains an ImpersonationMode that that is not supported for processing operations. 0 0 Error 2 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works DW', Name of 'AdventureWorksDW'. 0 0 Error 3 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Customer', Name of 'Customer' was being processed. 0 0 Error 4 Errors in the OLAP storage engine: An error occurred while the 'Customer Alternate Key' attribute of the 'Customer' dimension from the 'Analysis Services Tutorial' database was being processed. 0 0
View Replies !
View Related
How To Combine Date And Time Before Import Data?
I have extracted the data from Point of Sales. it has two columns one for date and one for time in the database. I need to combine both column into single column with the format "mm/dd/yyyy hh:mm:ss" before i import the data into the SQL server for my BI project. Example: Data extract from Point of Sales FDATEFTIME 20060114063616 20060115070743 20060116071020 How can i combine those two when i import into SQL server like below: FDATE 01/14/2006 06:36:16 01/15/2006 07:07:43 01/16/2006 07:10:20 million thanks.
View Replies !
View Related
Need To Combine String Data From Multiple Columns Into One Column
When quering a table with given criteria, For ex: select notes, jobid, caller from contact where status in (6) and jobid = 173 I am getting this: This job will be posted to Monster for 2 weeks. 173 906 Waiting for full budget approval 173 906 TUrns out we're uppin 173 906 What should I do so that these three columns for the same jobid from the same caller appears in only one column, either separated by a comma or semicolon? Please HELP!!!!!
View Replies !
View Related
Combine Tables From 2 SQL Servers With Different Schemas And Update As New Data Is Entered
I have 2 SQL server 2000 machines, I need to take a table from each one and combine them together based on a date time stamp. The first machine has a database that records information based on an event it is given a timestamp the value of variable is stored and a few other fields are stored in Table A. The second machine Table B has test data entered in a lab scenario. This is a manufacturing facility so the Table A data is recorded by means of a third party software. Whenever a sample is taken in the plant the event for Table A is triggered and recorded in the table. The test data may be entered on that sample in Table B several hours later the lab technician records the time that the sample was taken in Table B but it is not exact to match with the timestamp in Table A. I need to combine each of these tables into a new SQL server 2005 database on a new machine. After combining the tables which I am assuming I can based on a query that looks at the timestamp on both Tables A & B and match the rows up based on the closest timestamp. I need to continuously update these tables with the new data as it comes in. I havent worked with SQL for a couple of years and have looked at several ways to complete this task but havent had much luck. I have researched linked servers, SSIS, etc Any help would be greatly appreciated.
View Replies !
View Related
Combine Data And Split Into Separate Txt Files For Each Header/detail Row Groupings
I€™ve created with the help of some great people an SSIS 2005 package which does the follow so far: 1) Takes an incoming txt file. Example txt file: http://www.webfound.net/split.txt The txt file going from top to bottom is sort of grouped like this Header Row (designated by €˜HD€™) Corresponding Detail Rows for the Header Row €¦.. Next Header Row Corresponding Detail Rows €¦and so on http://www.webfound.net/rows.jpg 2) Header Rows are split into one table, Maintenance Detail Rows into another, and Payment Detail Rows into a third table. A uniqueID has been created for each header and it€™s related detail rows to form a PK/FK relationship as there was non prior to the import, only the relation was in order of header / related rows below it when we first started. The reason I split this out is so I can massage it later with stored proc filters, whatever€¦ Now I€™m trying to somehow bring back the data in those table together like it was initially using a query so that I can cut out each of the Header / Detail Row sections into their own txt file. So, if you look at the original txt file, each new header and it€™s related detail rows (example of a cut piece would be http://www.webfound.net/rows.jpg) need to be cut out and put into their own separate txt file. This is where I€™m stuck. How to create a query to combine it all back into an OLE DB Souce component, then somehow read that souce and split out the sections into their own individual txt files. The filenames of the txt files will vary and be based on one of the column values already in the header table. Here is a print screen of my package so far: http://www.webfound.net/tasks.jpg http://www.webfound.net/Import_MaintenanceFile_Task_components.jpg http://www.webfound.net/DataFlow_Task_components.jpg Let me know if you need more info. Examples of the actual data in the tables are here: http://www.webfound.net/mnt_headerRows.txt http://www.webfound.net/mnt_MaintenanceRows.txt http://www.webfound.net/mnt_PaymentRows.txt Here's a print screen of the table schema: http://www.webfound.net/schema.jpg
View Replies !
View Related
OLAP And/or Data Mining?
Hello,If I wrote the next ebay (yes I know, yawn-snore) and I had a databasewith 5 million auction items in it, what would be a really goodstrategy to get a search done very quickly? Would it involvesomething called OLAP and/or "data mining"? The only technology I amfamiliar with is simply SQL Server databases with stored procedures.I think I'd be guessing correctly and say that this technology simplywouldn't be fast enough *on it's own* to do super fast queries againstmassive amounts of data.Any insights would be of great interest. Thanks.-Frameworker.
View Replies !
View Related
DSN Data Source For OLAP
I am starting using OLAP service. The first problem the first day I use it. I setup a system DSN for OLAP under ODBC source. I use SQL driver to create a data source to a SQL server. I am using SQL SA login account. Then I go into OLAP manager create database. Then in the library I set up a data source using the DSN I created before.In the General Tab I use OLE DB for ODBC provider. After this I try to create a new cube using the wizard. I got error the message that the SQL login is invalid. I double check it is right login account. I failed several times. Then I tried directly create data source under library and not using the DSN I created before. The first time it failed again has the same message. Then the second time when I create data source I use NT authentication instead SQL login. Now everything went fine. I was able to create a cube. But I still wondering what is preventing using SQL login account when creating data source. Thanks for the help
View Replies !
View Related
DataDirect Technologies Releases DataDirect XQuery To Simplify XML And Relational Data Integration
[ANNOUNCE]DataDirect XQuery(TM) is the First Embeddable Component for XQuery Thatis Modeled after the XQuery API for Java(TM) (XQJ)BEDFORD, Mass.--Sept. 20, 2005--DataDirect Technologies(http://www.datadirect.com), the software industry leader instandards-based components for connecting applications to data and anoperating unit of Progress Software Corporation, today announced therelease of DataDirect XQuery(TM), the first embeddable component forXQuery that is modeled after the XQuery API for Java(TM) (XQJ).Developers can download a free trial of DataDirect XQuery today at:http://www.datadirect.com/downloads...query/index.ssp"Internet developers typically spend much of their time creating andrestructuring XML, using data from many sources, generally includingrelational data. This task is much too tedious in most environments.Using DataDirect XQuery, which is based on the W3C's XML Query(XQuery), simplifies the programming task significantly, solving thesame problems with much less code," said Jonathan Robie, ProgramManager for DataDirect XQuery and an editor of the W3C XQueryspecification. "Using DataDirect XQuery means that your applicationscan run on any Java platform, accessing data from the major relationaldatabases, using any Web server or application server, or using noserver at all. And DataDirect XQuery performs quite well, even whenyour query creates large XML results."DataDirect XQuery supports all major relational databases, includingOracle, Microsoft SQL Server 2000, IBM DB2, and Sybase, on any Javaplatform, allowing developers to query XML, relational databases, or acombination of the two. Query results can be used for XML-based dataexchange, XML-driven Web sites, and other applications that require orleverage the power of XML. DataDirect XQuery provides IT professionalswith a highly productive, powerful, simple, and standards-basedapproach to XML and relational data integration.Simplifying XML and Relational Data IntegrationDataDirect XQuery simplifies XML and relational data integration byproviding developers with an XQuery implementation that offers greaterproductivity, performance and interoperability for buildingstandards-based data integration applications, and here's how:· Productivity: Web services, Web sites, data integration, andpublishing are just a few examples of the many types of applicationsthat need data from many sources, including relational and XML. For thefirst time, DataDirect XQuery enables developers to easily process bothXML and relational data using industry-standard XQuery. DataDirectXQuery simplifies application development by reducing the amount ofcode developers write and maintain to use XML and relational datatogether. The result: reduced application complexity, shorterdevelopment cycles and more powerful applications - all based on thecurrent W3C XQuery standard yet to be finalized.· Performance: DataDirect XQuery optimizes and mediates queryperformance when accessing relational data. DataDirect XQuery isdesigned to move the minimum amount of data out of the database - forexample, XQuery code is converted to SQL statements which are executedon the database server - thus providing the best performance possible.· Interoperability: It's easy to embed DataDirect XQuery inapplications: it does not require any other product or applicationserver, it has no server of its own, it is not tied to a specificvendor database or database version, and it is based on the currentversion W3C XQuery and XQuery API for Java (XQJ) standards yet to befinalized. Application developers can write one easy-to-maintainapplication, regardless of the databases and versions they are using -Oracle, DB2, Microsoft SQL Server, or Sybase. This approach results inmore extensible and interoperable applications which are insulated fromthe frequent database updates and changes in the database vendor tools."In the past, our web-based XML Human Resources applications generatedand sent XML data using data stored in an Oracle database," said MarkZimmerman, VP of IT, at Gevity, a leading provider of employeemanagement solutions. "We found DataDirect XQuery to be fast, scalable,and reliable. And because DataDirect XQuery allows us to leave the dataaccess code in the middle tier, and not tied to a specific database,our application is insulated from any changes in the back end,improving application interoperability. Overall, we're very pleasedwith DataDirect XQuery.""Most XQuery implementations either work only with XML files in memory,or are bound to a particular database or application server - these areserious restrictions if your organization or partners have differentdatabases, require scalability, or need to integrate with legacy data,"said Jerry King, Vice President of the XML Products Group at DataDirectTechnologies. "DataDirect XQuery is the first and only product thattruly makes your XQuery just as portable as your XML - you can use iton any Java platform, with any major relational database, and itintegrates seamlessly with your Java applications using an industrystandard query language and processing API. DataDirect XQuery is aquantum leap forward in data integration technology, providingdevelopers with more power, performance and interoperability than everbefore, and developers can download and try it out today."AvailabilityDataDirect XQuery is available today. For more information, pleasecontact Nancy Vodicka at 919-461-4326, or visit our Web site atwww.datadirect.com/xquery. Developers can also download the DataDirectXQuery for a free 15-day trial at:http://www.datadirect.com/downloads...query/index.sspAbout DataDirect TechnologiesDataDirect Technologies is focused on standards-based dataconnectivity, enabling software developers to quickly develop anddeploy business applications across all major databases and platforms.DataDirect Technologies offers the most comprehensive, proven line ofdata connectivity components available anywhere. Developers worldwideat more than 250 leading independent software vendors and thousands ofcorporate IT departments rely on DataDirect® products to connect theirapplications to an unparalleled range of data sources usingstandards-based interfaces such as ODBC, JDBC and ADO.NET. Developersalso depend on DataDirect to radically simplify complex dataintegration projects using XML products based on the emerging XQueryand XQJ standards. DataDirect Technologies is an operating unit ofProgress Software Corporation, a US$300+ million global softwareindustry leader. Headquartered in Bedford, Mass., DataDirectTechnologies can be reached on the Web at www.datadirect.com or byphone at +1-800-876-3101.DataDirect and DataDirect XQuery are trademarks or registeredtrademarks of DataDirect Technologies Corp. in the U.S. and othercountries. Java and all Java based marks are trademarks or registeredtrademarks of Sun Microsystems, Inc. in the U.S. and in othercountries. Any other trademarks contained herein are the property oftheir respective ownerContact:DataDirect TechnologiesNancy Vodicka, 919-461-4326Join Bytes!
View Replies !
View Related
Pull Olap Data Using SQL Commands?
I have an OLAP server and would like to use my Chart FX software without having to purchase the OLAP extensions on the server due to budget restraints (ouch). I've heard that it is possible (although limited) to attach toan OLAP cube using SQL select statements (not MDX). Basically, I would like to pull the OLAP data in the relational sense. Is this possible? If so, are any good articles on this subject? I'm new to OLAP and would like to transition slowly. Thanks in advance :)
View Replies !
View Related
OLAP Drillthrough For Null Data
Hi: The drillthrough in my cube is working fine except for the cases where the dimension member is null. For example I have the dimension PRODUCT (dim) - PROD_TYPE_CD (name = PROD_TYPE_CD || '-' || PROD_TYPE_NM) - PROD_CD -PROD_NM So for if the data is like the following where the PROD_TYPE_CD is null : - (name = -FOOD) - 123 - bread The drillthough is not displaying any data no matter I select the PROD_TYPE_CD, PROD_CD or PROD_NM in the dimension drop down altough if query the DB directly I found data to display in the drillthrough Any ideas why this is happening and how to solve it. Thanks J
View Replies !
View Related
Extracting Olap Data Into SQL Using SSIS
I am using data flow task.And data flow source uses ole db for olap 9.0 to connect my ssas. sql comment is my access mode. A mdx query extracts data. Data flow destination is sql server table. Error said Data Flow Task: OLE DB Source [579]: The output "OLE DB Source Output" (589) references an external data type that cannot be mapped to a Data Flow task data type. I guess it is a implicit data type convertion problem. But how to solve it??? I appreciate for all suggestion. Thanks.
View Replies !
View Related
Accessing OLAP Data From SSIS
After reading some threads on this forum about accessing OLAP data from SSIS via an OLE DB Source component (and trying it myself and getting that "pcrsstore.cpp line 325" error), I have worked around the problem by using a Script Task component. This calls a .NET assembly I wrote that uses ADOMD.NET to get at the data using an MDX query, and then actually posts an event to a Notification Services instance via a stored proc. Writing, deploying, and maintaining a .NET assembly is more than I wanted to do, but it was worth the effort since now I know a little about extending SSIS when I need to. But what I really wanted to do was the following, all from within the core components of SSIS: Import my OLTP data into my relational warehouse (already done using SSIS) Process the cube (already done using SSIS) Access the cube via MDX and post an event to Notification Services It's this last step that needed some special work because of SSIS's apparent limitation accessing cube data (although posting the event to NS would be easy because SSIS can call a stored proc on the NS application database). So I'm hoping that a future release or service pack of SSIS will give us some components to run MDX and get the OLAP data into the pipeline as if it were from any other source. Thanks for reading, and if anyone has any suggestions on a better way to achieve what I need please let me know! -Larry
View Replies !
View Related
OLAP Report Data Source
I prepared an OLAP cube for the report data source in the SSAS 2005. The OLAP cube consists of more than 20 dimensions and several measure groups. I then created the subset/view of the OLAP cube using the "Prepective" function and limit to not more than 7 dimensions on each of the subset. How do I reference the OLAP cube subset as the data source when developing the report in the report designer. Furthermore what is the advantage of creating multiple smaller OLAP cubes with less dimensions comparing to one big OLAP cube with several subset/view attached to it. Thanks.
View Replies !
View Related
.net Based Control For Viewing OLAP Data
Hi, We are tryign to build web based custom applications to provide our OLAP data to users. I am looking at various products to do this. The objective is to use existing cubes on Analysis server and provide drill downs with data and chart. 1. Business Intelligence Portal from Microsoft. (buggy and not much customisable) 2. Visual Studio .NET Web Control for Business Intelligence http://www.microsoft.com/downloads/details.aspx?FamilyId=4599B793-B3C6-4ED5-ACB3-820D0E832151&displaylang=en (I could never get this control to work) 3. http://www.intellimerce.com/Snowflake.html If anyone has experience with similar application, will you pelase share? Thanks,
View Replies !
View Related
Ms Olap Connectivity Issues In DATA Analyzer
Can someone point me to a good resource for understanding connectivity to msolap. When I open Microsoft Data Analyzer and create a connection using connection type "server", what kind of connection am I opening and what are its dependencies on the client side and the server side? I have been experiencing issues with the data analyzer either not getting a connection at all or only seeing some cubes but not all. If anyone has some experience with this which they would like to share I would be most grateful.
View Replies !
View Related
Data Mining Model Based On OLAP
Good Morning, I have built a cube and created a data mining model with the 'price' prediction based on the cube. I got the following after processing. Value column represents the 'price' column of the cube. Following got 10964 cases of people spending '129916.5', but the highest spending by a case (customer) in the database is 15684.30. Could you please tell me how the value '129916.5' was arrived and what exactly it means? ValueCasesProbability (Tree Total)118934100.00% 654.6352444020.55% 1819.571467912.34% 171.056885157.89% 129916.5109649.22% Missing00.00% Following are some of the highest value records in the facts table. _______________ Cust NoProduct Value 09338147 Despatch Order 15684.30 11345238 Despatch Order 14530.50 06480986 Despatch Order 10772.25 03758485 Despatch Order 8976.00 09384984 Despatch Order 8347.50 09039673 Despatch Order 7612.00 10124883 Booked Ferry 1958.20 12565052 Booked Ferry 1902.00 09518514 Booked Ferry 1785.50 10226825 Booked Ferry 1752.00 11078352 Booked Ferry 1685.10 08686968 Booked Ferry 1670.00 10108130 Booked Ferry 1665.00 11443236 Booked Ferry 1661.00 12570801 Booked Ferry 1632.00 1165336X Booked Ferry 1626.00 10333848 Booked Ferry 1620.00 12293933 Booked Ferry 1604.00 13221292 Booked Ferry 1584.00 09487359 Booked Ferry 1582.22 10877708 Booked Site 1564.10 13796082 Booked Ferry 1555.00 04410300 Booked Ferry 1554.50 11356054 Booked Ferry 1554.00 12642290 Booked Ferry 1550.05 13733473 Booked Ferry 1544.50 0948260X Booked Ferry 1535.00 13124250 Booked Ferry 1534.70 1322072X Booked Ferry 1532.00 07445325 Booked Ferry 1531.00 _______________ Thanks, John Jayaseelan
View Replies !
View Related
Generic Data Sources For OLAP Cubes
Hi All, I'm trying to get some info on generic data sources for MS-OLAP cubes. I heard from that by using generic data sources we dont need to change the data sources when we copy and paste cubes from development server to producton server,Is this true? I greatly appreciate if anyone can suggest any Info resouces on Generic Data Souces for MS-OLAP Cubes acessing data from MS SQL 2000. Thanks, Paris
View Replies !
View Related
Performing A Query On OLAP Cube Data
Hi folks This is my code EXEC sp_addlinkedserver @server='joe_2', @srvproduct='', @provider='MSOLAP', @datasrc='server', @catalog='foodmart' SELECT * FROM OPENQUERY (joe_2, 'SELECT [customer], [quantity] FROM sales') The first part executes OK. The 'select * from OPENQUERY' gives me the error "Could not locate registry entry for OLE DB provider 'MSOLAP'" When I run SELECT a.* FROM OpenRowset('MSOLAP','DATASOURCE=joe_2; USER ID=; PASSWORD=;Initial Catalog=FoodMart;', 'SELECT Measures.members ON ROWS, [Product Category].members ON COLUMNS FROM [Sales]') as a go I get the same error Any thoughts Thanks in advance
View Replies !
View Related
Changing The Data Source Name For An OLAP Cube
Does anyone know how to rename the data source name in an OLAP cube? I have moved a cube and data from one file server to another using the Archive and Restore facility. If I edit the data source on the new cube I can change the connection and the database to reflect the change of servers but not the name of the connection itself. I know its a bit picky but I like to keep a clean and tidy house!
View Replies !
View Related
OLAP Server Returns Incorrect Data
I'm working with PivotTable on Excel 2000 which is connected to an OLAP server (from SQL Server 7 installation). The pivot is intended to analyze Sales during April 2001. Yesterday I found out that OLAP/Excel returned/displayed inconsistent data. The 'April Total' value is NOT equal to the 'Quarter 2 Total' (I already inspected the underlying database and sure that there is absolutely NO data for months after April 2001). The value for 'April Total' is the correct one. I'm not sure whether the problem resides on the OLAP Server or Excel (pivot) itself. For ones who like to help me I would be glad to supply you with the screenshots (just email me). Please help. Regards Dave
View Replies !
View Related
|
TRACKER
