Mining On Olap Cubes
Dec 26, 2007While creating a model, i can access to relational tables as data source, but not to olap cubes. Is it possible to browse olap cubes for mining? If yes, how? Thanks...
View 4 Replies
ADVERTISEMENT
HELP OLAP Cubes
Mar 3, 2004When I try to modify a OLAp Cube, suddenly appears a Error message
"Unknow Error. Restart the Application"
And this break my cube down
This is not always, just some time, for example when I proof the cube on Microsoft Excel or After I backed up the databes of analysis
What can I do?
I'll thanks your quick answer
NOTE: My cube use MOLAP aggregations
Distributing OLAP Cubes
Aug 18, 2000I'm looking into adding OLAP Cubes as part of our software to be distributed with our OLTP and eventually OLAP databases.
Is there any books that deal with distributing OLAP Cubes and or security.
Our clients will have SQL Server with our databases.
Thanks
Scripting OLAP Cubes
Mar 16, 2000Is there a way to script your OLAP cubes created in OLAP Manager to e.g. text files with CREATE CUBE and SELECT INTO statements.
View 1 Replies View RelatedOLAP Cubes And Programming
Jul 20, 2005I cannot seem to find a group where this question would fit so I amposting it here. I have what I believe is a unique situation. I amusing SQL Server Analysis Server to build a cube of "snapshot"month-end type of data. This data is from an instance of MicrosoftNavision and I have successfully used SQL-DMO and DTSPackage Libraryobjects to allow the user to rebuild the cube through Navision. Thisis accounting data and as such, the accountants want to be able toarchive this data by month. I know through Analysis Server Managerinterface I can copy the cube and save it to a different name.I would like to know if there is a way to programmatically save a cubeto a different name with some type of automation object?Thanks
View 1 Replies View RelatedReports With OLAP Cubes
Apr 19, 2006Hi
I try to design a report with Chart based on an Analysis Services Data source...
It does'nt work !!!
Has anyone else the same problem??
User Rights In OLAP Cubes
Jul 12, 2000How can we allow users to access a MS SQL Server OLAP cube but restrict the level of data that he might see?
I mean, if there is a cube with data for three different countries. How can one user be restricted to see data pertaining to
only one of the countries and not the other two countries?
OLAP 2000 - Cubes - Filters
Sep 14, 2000Does anyone know the best way to set up filters against the Cube data.
Ex. The Cube was built with data for 1998,1999, 2000.
The totals and the rollups will include the value for all years.
Client A want to access the Cube Data through Excel 2000 but only wants to see the values for 1999 - with the correct totals and rollups...
I know you can uncheck the other years in the filters in excel, but the totals and rollups will still include the values summing for all years.
Is there away to pass in a query on the fly?
Thanks.
Automatically Refreshing OLAP Cubes...
Dec 14, 2000Can someone tell me how you can automate the refresh of OLAP Cubes? I just inhereted a data warehouse running on SQL7 and the idea of having to go in and manually refresh the cubes everyday is, well... stupid. I can't believe that they've been doing this for a year. Unfortunately, I'm not familar enough with MSOLAP yet and I can't figure this out. Any tips?
View 2 Replies View RelatedMoving OLAP Cubes / Databases
Oct 9, 1999How can I move OLAP Databases / specific cubes or virtual cubes from our Development Server to the UAT or LIVE servers ?
Thanks,
Lee
ADHOC Reports Using OLAP Cubes
Mar 13, 2008Hi,
i want to know whether it is possible to develop ADHOC reports using SSRS 2005 and OLAP Cubes. the requirement is the user should be able to select the columns he wants to see in the report.
I think this requires Dynamic RDL generation. It is very urgent. i have to give POC to the client on this. Any help in this regad is appreciated.
Thanks,
Srik
Question On OLAP Cubes Storage Modes
May 24, 2007Hi, all experts here,
Thank you very much for your kind attention.
I am having a question on the SSAS2005 OLAP Cubes storage modes. We know SSAS2005 supports 3 different storage modes: ROLAP, MOLAP, HOLAP.
Do all these three storage modes of cubes store data in another physica analysis services databases which are inrelative from their data warehouse (in case they are built on top of the data warehouse)? (so it does not matter at all even we remove the data warehouse?)
Thank you very much in advance for your help and I am looking forward to hearing from you shortly.
With best regards,
Yours sincerely,
Windows Forms: Can You Deploy OLAP Cubes Through Winforms?
Nov 16, 2007Hi all,
Does anyone know if its possible to set up OLAP Cubes in a Winform?
Thanks,
Rob
Analysis :: Create OLAP Cubes Using NAV 2009 SP1 Database
Feb 13, 2012I am attempting to create som OLAP cubes using the NAV 2009 SP1 database. I am using Jet Enterprise with TimeXtender4 to build the cubes.
View 5 Replies View RelatedMining Cubes Vs Relational
Nov 21, 2006I've not found much guidance so far about the pros and cons of mining OLAP cubes vs their underlying fact and dimension tables. Can anyone offer advice in this area, or point me to more info about this?
Thanks,
Kevin
How Can We Deal With Unknown Member In Cubes For Data Mining?
May 24, 2006Hi, all here,
I currently have a question about unknown member in cubes (as we know, there is always an additional member called unknown in an OLAP dimension)for data mining. I mean is there any way for us to deal with unknown member in cubes when mining cubes?
Thanks a lot in advance for any guidance and help.
I Have Created The Cubes And Dimension And Mining Structure - How To Do Reporting
May 16, 2007Created:
Cubes
Dimension
Role
Mining Structure
From Analysis Services, how do I now use reporting services to show the Data?
OLAP And/or Data Mining?
Jul 20, 2005Hello,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 5 Replies View RelatedOlap Mining - Advantages, Disadvantages And Problems
Jan 19, 2007Dear Sirs and Madams,
it's quite hard to find informations about OLAP mining I think. So I have some questions to you:
What advantages do I have by using Olap Mining instead of "normal" mining (relational databases)?
Is it just faster or are there other advantages?
What are the disadvantages? The data can be overaggregated (no detailled results), can not? Are there other disadvantages?
What problem do I have to face?
Whats going on with empty cells?
Thank you very much in advance and have a nice weekend.
Thorsten
DMX Export Command On OLAP Based Mining Structure
Mar 13, 2008Hi,
I've tried to use the export command to export a mining model from management studio, but it returns that
export statement is not supported for OLAP mining structures, Ive checked the EXPORT(DMX) reference I can't see any note that it is not applicable on OLAP structures.
Can anyone confirm this?
-Rgds,
Sheryaar
On The Subject Of Data Warehouses, Data Cubes && OLAP&….
Jul 20, 2005On 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 7 Replies View RelatedTransfer Data(Cubes+virtual Cubes) From Sql2000 To Sql 2005
Jun 6, 2006Süleyman writes "I want to transfer databases with cubes and virtual cubes from SQL 2000 Analysis Server to SQL 2005 SQL Express.
1.how i can transfer the cubes?
2.how i can transfer the virtual cubes?
3.Why i see the tables(saw)and the cubes in SQL Managment only under Tables together and nothing under cubes?
Please help me
many thanks
Süleyman from Germany/Frankfurt am Main"
Where Can I Store The Mining Results From Mining Models In SQL Server 2005 Data Mining Engine?
Apr 26, 2006Hi, all here,
I am wondering where can I store my mining results in data mining engine? For example, I got mining results like accuracy chart, decision trees, and other formats of results based on different mining algorithms I used for my data mining, so where can I actually store the results for reporting service use later? Is it possible to do that in SQL Server 2005?
Thanks a lot for any help and guidance in advance.
OLAP Services: Automating Archival/Restore Of OLAP Databases
Sep 19, 2000Hello All,
Our OLAP environment involves an ETL/Data Warehouse/Data Mart server and a cube publisher server.
We would like to learn how to automate the Archival/Restore of OLAP databases. We are currently doing
it manually though OLAP Manager. Any help would be appreciated. Thanks. James.
--
James E. Bothamley
Senior Database Administrator
Dave & Buster's, Inc.
2481 Manana
Dallas, TX 75220
Work
Phone (214) 904-2296
email jbothaml@DaveAndBusters.Com
"Once in a while you can get shown the light
in the strangest of places if you look at it right"
JG 1942-1995 RIP
How To Repair A Corrupted OLAP Database? (was Olap!:)
Jun 12, 2007How to repair a corrupted OLAP database?
View 2 Replies View RelatedHow Is The 'Score' Value Derived In The Lift Chart/Mining Legend For Data Mining Models?
Sep 26, 2006Hi,
I have just run a simple data set through a model to predict a simple true or false value (i.e. binary output)
The Lift Chart/Mining Legend in Analysis Services shows three results €“ Score, Population Correct (%), and Predict Probability (%)
Population Correct I beleive is the percentage of predictions it got right out of the total number of predictions it tried to make. Is this correct?
However, I can€™t work out how the other two are derived in particular the 'SCORE'. To give a live example the scores were as follows:
Model Score Pop Correct Pred Probability
Decision Trees 0.83 76.59% 54.28%
Neural Network 0.75 67.63% 50.05%
Ideal Model 100.00%
Can anyone help with this and give a detailed explanation?
Many thanks,
S Rajput
Excel 2007 Data Mining Add-in Advance Create Mining Model Question
Apr 11, 2007Hi,
I am trying to model data in analysis services with the Advance Create Mining Model function in the excel addin. I am having trouble creating an association model that works like the Associate button above the Advanced button.
The format of my data is like this
OrderID Product
100 Bike
100 Helmet
100 Shoes
200 Helmet
200 basketball
200 Bat
300 Shoes
300 Socks
The associate button works perfectly since it asks me which column is the transaction id (orderid) and which column I am trying to predict (product). The advanced create mining model asks me to determine what the columns are...
OrderID=key Product=Input+Predict?
When I run the advance create mining model associate, I get a browser that gives me no rules and the support for only one item itemset (each product but no combination of products).
Does anyone know what I have to do to get it to work like the associate button?
Create Mining Structure And Mining Model With Code
Oct 18, 2006Dear friends,
I encounter a serious problem.
I would like to develop an application that can create Data Mining structures and a mining model in SQL Server 2005 with VB.NET. I tried the code from book Data Mining with SQL server 2005 in chapter 14 but did not work. Any good idea?
Please help me.
Best regards,
Manolis
Create Mining Structure And Mining Model With Code
Oct 20, 2006
Thank you very much for your help.
The errors that I can see in the code that you gave in your answer are the following and they are more or less the same as I had previously
I tried the code but initially I have encounter the following problems.
1. In any line that have the declaration As Server, As Database like in
Public Function CreateDatabase(ByVal srv As Server, ByVal databaseName As String) As Database gives me the problem that type Database is not declared the same type Server is not declared and it does not give me any option.
2. In addition to that for As DataSource, As RelationalDataSource, As RelationalDataSourceView, As ScalarMiningStructureColumn, As DataSourceViewBinding, gives me the problem that type is not declared.
3. Finally in mc = New MiningModelColumn("Yearly income", Utils.GetSyntacticallyValidID("Yearly income", Type.GetType(MiningModelColumn))) is not accesible in this context because it is 'Private'.
I have some more problems but I thing that by solving the above that I referred I will solve the rest.
Thank you any way.
Best regards,
Manolis
PhD student
Can I Filter The Data On Mining Structure, Mining Model?
Jul 18, 2006I perform data mining on all products and a specific product category.
Do I need to create 2 data source views, one for all products and the other one for the specific product category?
Afterward, I run the Data Mining Wizard 2 times to create 2 mining structures.
I also need to add the same mining model (e.g. Bayes, Cluster) to each of these mining structures.
Is there any simple way to do it?
Thanks.
Joe.
Mining Structure Has To Contain At Least 2 Mining Models To See Their Accuracy Charts?
Nov 27, 2006Hi ,all here,
Thank you very much for your kind attention.
I just found that I am not able to view the accuracy chart for my mining model. The error message is: no mining models are selected for comparision. Which is quite strange.
Any guidance? thank you very much.
With best regards,
Yours sincerely,
How Get The Lift Chart In Datamining.i Am Not Geeting Mining Accuracy Chart And Mining Model Prediction
Sep 14, 2007
Hi,
I am not getting Mining Accuracy Chart and Min ing Model Prediction
Plz tel me how to do.And how to use the filter input data used to generate the lift chart and
select predictable mining model columns to show in the lift chart
Data Mining :: Informational (Data Mining) - Decision Trees Found No Splits For Model
Sep 29, 2015I followed the tutorial posted at [URL] ...
Everything was ok until the last step where I had to process the mining structure which resulted in a warning
"Informational (Data mining): Decision Trees found no splits for model, Tbl Decision Tree Example."
What does this error mean? How do I resolve it? Also, I only see the first level in the Mining Model Viewer, I don't see the levels 2 and 3.