Create Virtual Cube From Local Cubes?

Oct 22, 2005

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

View 2 Replies


ADVERTISEMENT

HOW TO CREATE VIRTUAL CUBE?

May 20, 2008

Can anybody tell me how to create a Virtual Cube from two or more diffrent SSAS 2005 Cubes?

View 7 Replies View Related

Transfer Data(Cubes+virtual Cubes) From Sql2000 To Sql 2005

Jun 6, 2006

Sü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"

View 1 Replies View Related

Programmatically Create AS2005 Local Cube (C#)

Mar 4, 2008

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!

View 3 Replies View Related

Needful Parts Of MSSQL To Create Local Cube

Jan 16, 2004

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.

View 12 Replies View Related

Create && Filter AS2005 Local Cube Programmatically

Mar 12, 2008

Although 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();

View 2 Replies View Related

Unexpected Internal Error When Querying Virtual Cube Via DTS

May 6, 2008

I have a DTS package in SQL Server 2000 which brings together data from different sources, including from an Analysis Servcies cube, and compares it.
Usually this runs perfectly, but sometimes I get an unexpected internal error from the Data Pump task which queries the cube - no other information, just the error.

This is usually when I have run the package once (manually from Enterprise Manager), then changed a global variable and run it again.

The cube it is querying is a virtual cube and the measures are calculated cells (NOT calculated members).

We are on SP4 of AS so should be up to date.

Does anyone have any ideas?

Thank you

View 1 Replies View Related

How Can Users Download Cubes To Their Local Machines?

Apr 8, 2004

Hi,

I read in oneof the articles somewhere that users can also download cubes to their local machines for off-line browsing/analysis. This can be very useful if the user is suppose away from the office or not connected to the LAN.

I wanted to request if someone can explain the process of how users can do this i.e. download/save a copy of the cube to their local machines?

Thanks.

View 4 Replies View Related

Restrict Local Cube

Mar 13, 2006

Does anyone know how can we prevent users from creating offline/local cube (in Excel) from our OLAP/Analysis Service server ?
Thank you.

View 3 Replies View Related

OWC Cannot Open Local Cube???

Jan 20, 2008

Hi:



I have an ASP.NET web application with a pivot table OWC that reads data from a local cube.

Everything works fine when I run it locally but when I run it on machine client the pivot

table Can not open cube 'c:cube.cub'.



i have installed in the client the Version 6.0 of the Microsoft XML library (MSXML, Version

6.0) and Analysis Services 9.0 OLE DB Provider but it's not possible open cube.



i am creating the local cube with SQL Server 2005 SP2, with the Creat Global Cube Command.

maybe is it a problem ?



Any help at all would be greatly appreciated.



Diego Bayona

View 1 Replies View Related

Need To Create Package For Refreshing The Cubes

Apr 4, 2008



We have scenario where we need to create package for refreshing the cubes. Let me explain it breifly.

We are doing ETL process in different ETL tool (not SSIS) and once the process is done, we are inserting in a table where we have a column like date, Completed C as the status. Once we get this information i.e 'Completed C' status and date, we need to refresh the cube like as follows,

1. Previous day cube need to be refreshed daily once
2. Previous week cube need to be refreshed weekly once.
3. Previous month cube need to be refreshed monthly once.
4. Historical cube need to be refreshed daily once.

We have decided all these above operations needs to be done in SSIS. In this case what are the things to be done while creating a package.

1. What are the control flow items to create it in SSIS?
2. Is there any way to have pooling like every 10 minutes to check whether the table has 'Completed C' status and STOP EXECUTE this package?
3. Is there any way to check the date for Previous day cube, Previous week cube, Previous Month cube and Historical cube etc?


Thanks in advance,
Anand Rajagopal

View 7 Replies View Related

How Can I Connect OWC PivotTable To A Local Cube File?

Aug 4, 2004

:eek:

I want to use the Office Web Components (v10) PivotTable embedded in a web page. The examples and tutorials I've been able to find on MSDN all use the same architecture: The initial pivottable configuration is created by instantiating the object server-side and programmatically configuring it. The XMLDATA property is then read and sent to the client. At the client, script sets the XMLDATA property. So far so good, all makes sense. Then my problem: The PivotTable is then connected to Analysis Server using an http connection string (through IIS). As my users do not have database accounts, only application accounts, I cannot allow database connection information on the client. Trouble is, the PivotTable generates MDX queries when a user reconfigures the view, and there are no hooks (events or other means) to programmatically obtain the generated MDX query - a fact that is explicitly confirmed in MSDN documentation.

This clearly means that the PT must be connected directly to it's data source. So I thought I could just create a local MOLAP cube file and download it to the client (permissible as it runs as a trusted application). But nowhere can I find any example or documention on how to do this.

This is driving me slightly insane and I have little hair left now; if anyone knows how to do it or where to find proper PivotTable documentation (rather than a collection of examples that do something else from what I need to do!) then help is greatly :p appreciated!

Dag

View 1 Replies View Related

Analysis :: Writeback To Local Cube File Possible?

Nov 11, 2015

We are using a SSAS Server in order to analyse financial data. To create forecast scenarios, we would like to use the "what-if-analysis"-feature of Excel.  With this feature, data that was changed in Excel can be written back into the cube.

There are several data analyists who should be able to create scenarios on their own, that's why, each of them gets his own offline cube (a .cub file that is stored in the file system) whose data is extracted from the SSAS Server. 

Unfortunately, we found no way to write back data in these offline cubes. Due to the error message,  Excel failed to establish a connection to the external data source. Is there a way to writeback data to a local cube?

View 2 Replies View Related

Is Possible To Create Dynamic Reports Based On Cubes?

Sep 5, 2007



Hi,



I would like to know if is possible to create dynamic reports based on cubes. What i mean is,after creating a cube with a couple of dimensions and measure if is there any way to give the normal users on the report manager or report builder the freedom to choose their own dimensions/measure so they can output the report with the choosen criteria.

Thanks.

View 3 Replies View Related

Analysis :: Create OLAP Cubes Using NAV 2009 SP1 Database

Feb 13, 2012

I 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 Related

Error: Create Virtual Directory

Feb 19, 2008

hi all,

I Installed SQL server 2005, installation completed with out any warnings.
but when trying to configure reporting services it is not configured and throwing error msg as create virtual directory.

and the error msg looks like

"
ReportServicesConfigUI.WMIProvider.WMIProviderException: The virtual directory specified is not valid. Make sure the specified name is not too long and doesn't contain illegal characters. (example: ;)


at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.CreateVirtualDirectory(String virtualDirectory, String path)
"

pls give me any suggestions, Thanks for any help

sql9

View 2 Replies View Related

Cannot Create Named Instance Virtual Directory

Jun 8, 2007

We regularly deploy our product to client's sites and install a named instance of SQL Server 2005 and Reporting Services on their Windows Server. We use the instance name "lgs" during SQL setup and it automatically ensures we have a http://server/Reports$lgs and http://server/ReportServer$lgs to work with.



A recent deployment had some trouble with their OS and we have needed to reinstall the Reporting Services component of SQL. After reinstalling, the virtual directories for Reports$lgs and ReportServer$lgs are gone. I have used the Reporting Services Configuration tool to create new virtual directories but when I enter Reports$lgs or ReportServer$lgs as the names I get an error. The error says that the virtual directories cannot

be created due to illegal characters in the names.



How can I create the same virtual dirs that would have normally been created during initial installation?


Thanks,



- Jason

View 1 Replies View Related

How To Create A Real (not Virtual) Table From View1 && View2 Ni Sql Server?

May 11, 2006

Hello all,my question might be trivial but since my background isn't DB i'll dareto ask it any way:how to create a real (not virtual) table from view1 & view2 ni sqlserver?what should i do specificly in the sql server application & what is thesyntax for that?i thank all of you,groupy.

View 2 Replies View Related

Create Database On A Virtual Drive (Created With Subst) Failed

May 26, 2007

When I try to add a (SQL Server 2005 Express Edition) database to my project (I'v tried a windows application and an ASP.NET application) in Visual Studio 2005 Professional Edition; It fails with an error like this :
"create database failed. some file names listed could not be created (...)"
but when I open the project from the real path It works.
Is this a bug? Is there any solution? (In many situations there is a need for working with virtual drives. There must be some work around ...)

Thanks

View 1 Replies View Related

How To Create Cube

Jul 20, 2005

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 Related

Can I Create A Cube By VB.net

May 24, 2007

can 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.

View 4 Replies View Related

Create A Cube

Dec 5, 2007



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

View 1 Replies View Related

How To Create Cube In Sql2005?

Aug 17, 2007

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

View 1 Replies View Related

How To Create New Partition On A Cube

Jan 12, 2012

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] .....

View 2 Replies View Related

SQL 2012 :: Create Cube Permissions?

Nov 19, 2014

I 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.

View 0 Replies View Related

How To Create Cube In SQL Server2000/2005

Nov 1, 2007

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

View 1 Replies View Related

Analysis :: Create Cube With 2 Table

May 6, 2015

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

How To Create Partitions On Cube Using SSIS?

May 5, 2008



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

View 11 Replies View Related

Is It Possible To Create Cube File Without Microsoft Analysis Services

Aug 11, 2004

Can I create a cube file, .cub ,without the Microsoft Analysis Services

Pls Guide me as I am new in this field.

Thanks
Loyd

View 3 Replies View Related

Analysis :: How To Create MOLAP / ROLAP And HOLAP Cube

Aug 11, 2015

creating MOLAP, ROLAP and HOLAP cubes... I'm looking for detailed steps involved.I'm using MS-SQL Server 2014.

View 2 Replies View Related

How To Create Cascading Parameters In A Report With Cube As Datasource

Mar 11, 2008



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.

View 5 Replies View Related

How To Create Report Model Project For OLAP Cube

Sep 18, 2007



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

View 3 Replies View Related

MDX In Analysis Services: Create A Cube-Based Hierarchichal Picklist

Feb 7, 2008

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.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved