I am new in SQL sever Analysis Cube. Can anyone help how to create Analysis server cube in sql server 2000/2005 by with some sample that clarifies how to do what I want to do, or give me some direct advice?
Thanks
Pravat Sharma
hi
at my work place some of the users migrated to another domain even thought with new domain name they can access SQL Server but user who are part of sysadmin(part of some group) on the box unable to execute a job. it means at operating system level newdomainuser credentials are get resolved that's why users are able to access box but why not able to execute jobs. why sysadmin Privilege not get resolved at SQL Server level very confused............
Hi,
I have a sql server 2000 backup and I want to restore it into a Sql Server 2005 database.
I did the restore on the usual way. All the database tables were created, but the data didn't get restored.
Pls help!
Thanks!
Hi All,I want to create a cube using MSSQL2000 i dont know any thing how tocreate and what is parameter required so if any body help me i will bethankfull to him/her.For information : i have 4 tablescustdetailtable which contain all about a customer as per examplecustomer ID,name,add,CUSTOMERID IS PRIMARYKEY,Proddetail table which contain all about a product meanproductcode,productname,productvalue,dman (dateof manufacture),dexpdate of expire,etc etc PRODUCTCODE IS PRIMARY.Sales this table contain data aboutsale mean sales detailcusomerid,productcode,noofpieces,priceperunit,prod uct name,date ofsale. etc etc SALEID IS PRIMARYKEY,PRODUCTCODE AND CUSTOMERID ISFOREIGNKEY AND PRODUCTCODE IS PRIMARYKEY,and atlast i have a table name stok detail which contain productid,DTOFman and DTofexpire and amount of producthere product id,DTOFman and DTofexpire are foreign key.
View 3 Replies View Relatedcan i create a cube by VB.net?
I wanna a dynamic Cube, so I can not define it in the Analysis Services Project.
So the problems come.
I must deploy and process and compile the cube.
That can be done?
thank you.
Hi All,
i got a errors while creating a cubes. error comes like
Warning 1 Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_Fact_Trng, Column: fct_trng_per_from_key, Value: 5/25/2006. 0 0
could u please solve thisa problem
Hi experts,
I want to create a cube using sql2005. I have read some articles which told me to create it through Visual Studio and still i cannot find where i should do that. I cannot find an "Analysis Manager" UI in sql2005 or Visual Studio. If any body could help i will really appreciate. Thanks
I need to create a new partition on a Cube using T-SQL and I am not much aware of either the Cubes or the ActiveX script. I am writing a T-SQL script for creating this partition on a cube.
Select Case iMonth
Case 1,2,3
sQuarter = "1"
Case 4,5,6
sQuarter = "2"
Case 7,8,9
sQuarter = "3"
Case 10,11,12
[Code] .....
Can anybody tell me how to create a Virtual Cube from two or more diffrent SSAS 2005 Cubes?
View 7 Replies View RelatedI need to grant create cubes to developers, but if I include them into server administration role, then they could delete or modify all the databases.
Each developer require full administration on their own databases, but not other developer's databases.
i want to create cube withe 2 fact tables. is it possible?? if it is could you show me how !!
View 2 Replies View Related
Hi,
I am currently using SSIS ,MS Sql Server 2000 database and 2000 Analysis Services for the cube.
I am creating a new table everyday and giving name like day_20080504, day_20080505 etc...
So then I go to Analysis Services and process dimensions(incremental) AND
Create a new partition using old partition as a template.
My first question is how to create a new partition everday and use old partition as template...(Almost same except database table)
My Second question : Can I do this on 2000 Analysis services or Should I convert my cube into SSAS?
thanks,
J
I have a big problem to solve:
I use MsSqlServer 2000, Analysis service. I have cubes and virtual cubes. I have a dimension of consult, they have a hierarchy that change every month. for example: In june the consult "John" is in D11, in September he is on D14,...
Hierarchie: D10 -> D11, D12, D13 - > C1, C2..
For this reason when i want analysis The consult John in a year(12 months) my result is wrong. With this changes in the hierarchie my analysis become wrong!
I thought in the end of every month store the cube in a local cube, like a picture of every consult, with his sales e others measures. With this i can analysis the consult in a specific month rightly, but i need the anlysis in a year. And in a year i would have 12 local cubes, then i could acess them and do a right analysis. How could i access 12 local cubes? Can i create a virtual cube with this 12 local cubes? Is there another solution for this problem?
Thanks,
Leonardo
BI Analyst
Greetings,
Here's what I need to do. I need to programmatically create offline cubes for multiple customers. Using VS2005 (C#) and SQL Server 2000, I am able to do this using the CREATE GLOBAL CUBE command. However, I need to create cubes from SQL Server 2005 as we have upgraded and the CREATE GLOBAL CUBE command does not work as it did before. I've search and found examples using AMO, but they create a server cube. I already have a server cube.
I need to be able to create filtered offline cubes from the existing server cube. I've also read much on XMLA, but that doesn't do it for me either. The code below creates an empty offline cube. However, is there a way to use this to create a cube with data?
I am creating this in a windows application.
Server server = new Server();
server.Connect(@"Data Source=C:MyLocalCube.cub");
server.Disconnect();
Can anyone help? This is driving me nuts!
Can I create a cube file, .cub ,without the Microsoft Analysis Services
Pls Guide me as I am new in this field.
Thanks
Loyd
hi,
I'm creating local cube with Delphi. On my server with MSSQL it work well, but i need to know, which parts of MSSQL is needful to create this local cube (on the server) if i will creat and instal new server with MS SQL.
Thanks for reply.
creating MOLAP, ROLAP and HOLAP cubes... I'm looking for detailed steps involved.I'm using MS-SQL Server 2014.
View 2 Replies View RelatedAlthough I can create the local cube, the cube that is created is very large because it brings over all accounts for the employee. In AS2K, it filtered automatically and only returned accounts that had revenue, which is what I'm trying to do using AS2005. I've read some of the responses about using XMLA and AMO, but I am not sure how to use these within the VS2005 windows application that I use to create and distribute the local cubes. Does anyone have a good example of how to use XMLA, AMO or anything else that would allow me to programmatically create and filter offline cubes using C#?
For instance, this code DOES create an empty cube. But how would I go about getting data into this cube?
Server server = new Server();
server.Connect(@"Data Source=c:MyLocalCube.cub");
server.Disconnect();
I'm trying to create report with datasource as a cube. I'm able to connect to datasource to pull data with a single parameter. But, I'm unable to succeed in creating a cascading parameter.
The following scenario:
I have a dimension "Period" as Paremeter.
The Period dimension is cascaded to year- quarter- month.
So, I would like to create a cascading parameter for period as year - quarter - month.
Please let me know, how to acheive this.
thanks,
Naveen.
Hi ,
Please tell me how to create Data Source and Data Source View in Report Model Project for OLAP Cube.Whats the provider to use while creating Data Source in Report Model Project to make connection to OLAP Cube.
Thanks
Raghava
Mr. Pearson,
I am currently reading your article titled, "MDX in Analysis Services: Create a Cube-Based Hierarchical Picklist". This article is directly applicable to a problem we are currently trying to solve regarding ragged hierarchies as input parameters.
I have not read the entire article through but am in the process of doing so. Also, I will be trying to implement your solution.
I have one question, will SSRS support multi selection when using a hierarchical picklist? Thanks in advance for any assistance.
I am just starting out using CUBEMEMBER/CUBEVALUE formulas in excel linked into a sql olap db - using this method for some custom reports where pivot tables are not suitable.
The time dimension values include Months, Quarters and Years and the CUBEMEMBER formulas like
=CUBEMEMBER("OLAPCUBE","[Time].[Time].[Year].&[2015].&[1].&[1]") work fine - 1st quarter 1st month etc.
Is there a straightforward notation to aggregate months or do I need to use a plus sign to add a number of CUBEMEMBER formulas together.In other words - Is there an easier way of for say jan to july 2015 totals than
=CUBEMEMBER("OLAPCUBE","[Time].[Time].[Year].&[2015].&[1]") + (CUBEMEMBER("OLAPCUBE","[Time].[Time].[Year].&[2015].&[2]")) + (CUBEMEMBER("OLAPCUBE","[Time].[Time].[Year].&[2015].&[3].&[7]"))
I haven't tested this but have assumed it works but a bit long and clumsy.
I have problems creating a cube with AMO.
I can add the cube to the database object and fill it with dimensions and a measuregroup (see code below).
If I call cube.Update() it says something like "Error in meta data manager. Cube has no measuregroups." (getting the message in german language)
The error in Microsoft.AnalysisServices.OperationException.Results.Messages is -1055653629
I can't find any documentation about this (or any other) error code in Microsoft documentation.
Here's my Code:
Cube newCube = database.Cubes.Add("MyCube","MyCube");
newCube.Language = 1031;
newCube.Collation = "Latin1_General_CI_AS";
CubeDimension dim = newCube.Dimensions.Add("dim1","dim1","dim1");
CubeAttribute attrib = dim.Attributes.Find("dim1Attr1");
[code]....
Hi,
We wish to create cube in SQL Server 2005,
where we can create a cube using query.
Hi guys,
This is my first post. Could anyone help me out? I am trying to refresh a cube that i created by using a new script command but i get the following error "the script contains the statement, which is not allowed." On the microsoft page i've read that for refreshing you need to create a new script. Is there another way for refreshing the cube?
Cheers
When I make a call to GetSchemaDataset with a restriction of a cube name with a space in the name of the cube the call fails. Following is a sample of the code: adoRestriction = new AdomdRestriction("CATALOG_NAME", "Contoso Telecom_Contoso"); adoRestrictions.Add(adoRestriction); dataSet = conn.GetSchemaDataSet("MDSCHEMA_CUBES", adoRestrictions); I am running SQL Server 2005 Analysis Services SP2. Is there some way to qualify the cube name in the restriction or is this just a bug? Thanks.
View 1 Replies View RelatedHi,
I've been trying to use Analysis Services 2005 Cube as a data source, query it via MDX and then use the data returned elsewhere in SSIS.
However, I've been unable to get this working and can't find any information regarding how this can be done. Surely it should be possible when I can get this working even in Excel?
I've looked in December edition of BOL and no luck - have also sent a feedback to BOL regarding this and have been told that "it should be possible, since there is a way to send SQL queries to AS." However the person I was speaking with knew of no one who had actually tried this scenario and to try posting here.
Any help as to how to get this done would be greatly appreciated.
NR
I have this strange issue.
VS2005
SSRS2005
SSAS2000 cube based on data from SQL 2005 database
When i connect to the SSAS cube and create a dataset in a SSRS 2005 report i do not get a parameter pane.
Also, if i right click on a dimension & select "Add to filter" i get the following error message
"Object reference not set to an instance of an object"
It's not my installation of SQL 2005, as I can connect to an SSAS2005 cube and get the filter/parameter pane and do not get the error message. Parameters work fine.
Have i come across a known issue when reporting on SQL 2005 versus a SQL 2000 AS Cube... or can someone shed some light on the issue for me....
If someone can tell me how to display screenshots I can add them to a post
Thanks
Will
Hi!
Can I process a cube without error if there is an application that writes data into the source SQL Server database?
Do I have to stop that application every time when I want to process the cube?
can any one sugest Quering AS2005 Cube to generate CSV or Excel in SISS 2005
i have a mdx query that runs fine in SQLserver 2005 but when use OLEDN source in SSIS and connect to Flatfile source i am getting OLEDB exception is there any work arround i have SQL Server 2005 SP2 on Windows 2003
Any help is really appreciated
thanks in advance
Hi,
*every processing* of a cube with 7 dimensions 5 measure groups (no table has more than 100.000 rows) hangs while trying to process the measure groups. I have to restart the Analysis Service all the time. But even worse every 2nd processing crashes the whole Analysis Services Process.
The only time I could sucessfully deploy a cube was with 1 measure group only.
How can anyone do any serious work with Analysis Services?
The error messages from evenlog are not helpful either.
Thanks,
Tobias
EventType sql90exception, P1 msmdsrv.exe, P2 9.0.3054.0, P3 46048069, P4 msmdsrv.exe, P5 9.0.3054.0, P6 46048069, P7 0, P8 005e9430, P9 00000000, P10 NIL.
The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured..
Hola
We are getting symptoms of a 30 second timeout irrespective of what we do, but only on certain machines. Can anyone shed any light on how the connection timeout can be set, as there seems to be a factor overiding any settings we set?
We are working in Excel (2003) connecting to an Analysis Services 2005 cube through a website https://Datasource connection. When we edit the connection string that the file is using (either by forcing use of an exterior .ODC file and editing the settings in there, or by converting the xls spreadsheet into an xml spreadsheet and manually editing the connection string in there) we get no joy: after 30 seconds the error appears:
"Either a connection cannot be made to the [my server address], or Analysis services is not running on the computer specified".
This error is itself rubbish: If a smaller query (one that takes < 30 seconds) is run in the same Excel file and Pivot Table, it connects fine.
What really doesn't make sense is that the exact same file works on some machines and not others. These machines are all inside the same network (and the machines that work have been proven to work on a number of other networks). What's more there is no pattern to the machine capabilities - some newer / faster machines get the error. These machines (that work and do not) have excel 2003 SP3. (Another of the ones that works has Excel 2007).
Changing the connection string to include "Timeout=300" or "Connect Timeout=300" makes no difference, and "Command Timeout" causes a different error so that it wont even attempt to run the query (as opposed to collapsing after 30 seconds of normal progress).
Similarly in the .ODV the tags <ODC:CommandTimeout>, <CommandTimeout>, <ODC:Connect Timeout>, <ODC:Command Timeout>, <meta name=CommandTimeout content=1000> etc. have no effect (the file still gets the 30 seconds error rather than just giving up so no way of working out correct syntax)
The only pattern we can see, and we can't fix this, is that the machines that work have Retail versions of excel, and the ones that do not have corporately licensed versions of excel. We cannot see any difference between them in the Help >Abouts, but thought it might be worth mentioning.
Any help would be fantastically appreciated, we are out of ideas.
Thanks kindly
Amundo
When I try to install MS SQl server2000 on windows XP machine,it says the server component is not supported by OS.What should I do to get it run on my machine?
View 3 Replies View Related