As we know Mondrian Cubes are based on a schema.xml file. Schema contains a logical model, consisting of cubes, hierarchies, and members, and a mapping of this model onto a physical model. What is the difference between the structure of the SSAS
cubes and the structure of Mondrian Cubes?
Consider the following schema that defines a simple Mondrian cube:
View Complete Post
Hi all. I have a question regarding offline cubes (offline data files) in Excel 2007/2010 connecting to SSAS 2008 R2. When I try to make an offline data file in Excel
I get a OLE DB error. The server I am trying to connect to is at a hosting partner on a different (but trusted) domain but I have admin rights on it. I then took a copy of the SSAS database and moved it to my own pc and could then create offline data file.
I thought it might be a firewall issue on the server and tried turning it off, but the OLE DB error came again. I therefore think that there is something that happens over the network and is blocked by the hosting partner. I probably should tell that I am
also SSAS admin, so it is not because of lack of rights on the SSAS that I get the error.
What I like to know if there is anyone who knows this problem or knows what happens when you try to create offline data file against SSAS in Excel? Specifically what
is transferred between the client and the server, what ports and are there any programs run or code executed to create the offline cube on the client that might be blocked by typical network/domain settings/rules?
Master Package containing
a) A sequence of SSIS packages
c) Precedence constraint to
b) Analysis Services Processing Task to process our cubes
2. SQL Agent Job which runs the Master Package
Taking the cube processing in SSIS package and putting SSAS commands into the job
This seems to work, but we don't know why it is not working.
In BI SSAS cubes are working fine.
But SSAS cubes in SSIS package showing the following error
"Internal error: The operation terminated unsuccessfully. "
Pls help me to solve
Can someone help in understanding what type of account is needed for deploying/maintaining SSAS cubes in SSAS 2008 R2?
Does one have to be in the local administrators group on the SSAS server? Can a domain group/user (non administrator) be assigned to any role that enables them to deploy cubes etc. If so, what Impersonation Mode will be used from within the dev
studio while trying to depoly the project?
Can someone point to any documentation as well. I must not be searching right as I am not able to find an exact information.
I am having some management problems and need to prove that the cubes are available for browsing.
I have had a look at SSIS to see if there is a task but I suspect I need to script something out.
Can anyone give me any pointers ?
My company is not currently running SQL Server (much to my dismay). Prior to a few months ago, I was using MS-Query through Excel to build cubes for large datasets for OLAP (with Excel) analysis. Although clunky, this was still working for me. Then they
upgraded everyone to Excel 2007 and the new version of MS-Query no longer provides the ability to build OLAP cubes (again to my dismay).
I was wondering if there was a standalone download of SSAS or other (FREE) MS tool that would allow me to build OLAP cubes for analysis with Excel? A google search of "download SSAS" was not helpful. Can anyone point me in the right direction?
I am trying to add a fact table and two dimension tables from Teradata.But when i create a Data Source View,it does not allow me to pull all the three tables.I tried both the .NET and Ole Db Provider for Teradata.But no luck.Can someone
help me please
Can i use Process data option in SSIS Analysis services task for sheduling SSAS cubes.
Now im using Process Full option, It is taking 1 hour for processing 44 lakhs records.
If i use the Process data option whether it will reduce process timings..
or tell me the ways to reduce the process timing in scheduling.
If i use Process data instead of Process full any disadvantages there??
Please guide me..