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


ADVERTISEMENT

SQL 2012 :: Assign Create Stored Procedure Permissions?

May 6, 2014

Only to a specific schema? Can this be done?

View 5 Replies View Related

SQL 2012 :: Revoke Create Schema Permissions Without Removing DDL Permission?

Apr 17, 2015

I have a sql server 2012 server and I need to prevent the users from creating new schemas by mistake. Is there any way to revoke that permission alone but still letting the user to create their own objects in dbo (yes I know that shouldn't be in dbo but that is another issue).

View 2 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

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

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

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

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

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

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

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

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

Analysis :: SSAS 2012 - Notification While Cube Is Processing

Apr 16, 2015

I am working on SQL 2012.We have a SSAS Cube build. On top of it client use Excel to connect to SSAS Cube and See the reports.My Cube process every hour and take almost a 1-2 min to Process.When ever End user/Client See or refresh the Excel report (Which use Cube as Source),WHEN CUBE IS PROCESSING ,they get an error that Source is not available

We Have tried best but cannot bring down the Processing time of the cube to 3-5 Second , so that End user don't face report refresh issue at the moment of cube processing 

Requirement :In Case End User see the report while Cube is processing from back end , Instead of Error they should see some customize Msg which we can provide some thing Like "Data is Refreshing , please wait ".

View 5 Replies View Related

SQL 2012 :: SSIS Processing Of SSAS Multidimensional Cube Fails?

Oct 31, 2012

All I get back is an error message of "Analysis Services Processing Task Error: A Connection cannot be made. Ensure the Server is running" The server is running, I can process the cube by connecting to the AS instance and right-click processing it.

I can process the cube by running the SSIS task inside of SSDT Just when I deploy the SSIS package (in Project mode) and then execute it do I get the error message.

SQL Server, SSAS, and SSIS processes are all running under the same account. SSAS is on a separate server from SSIS and SQL if that matters.

View 2 Replies View Related

Permissions To Create A Stored Procedure

Apr 30, 2008

A simple one (not for me)

MS SQL Server 2005

Which permissions do I need to have (as a User) to create a Stored Procedure
Which other entity's properties do I need to change in order to create a Stored Procedure

Thanks

View 2 Replies View Related

Minium Permissions Necessary To Create A Login?

Mar 15, 2006

What are the minimum permissions necessary to use CREATE LOGIN?

I'm using db_accessAdmin and db_securityAdmin and db_owner. The user as access to the database.

It still says I can't create the login. What am I missing?

View 1 Replies View Related

Stored Procedure Create & Execute Permissions

Aug 27, 2002

In our development and test environments the developers need to create and execute stored procedures as dbo without having any other dbo permissions. If I place them in db_owner, they have too many permissions. Is there a way to address this situation?

I'm also curious how other companies address the subject of creating stored procedures in development and test environments. If I give developers create and execute permission in a database, all objects would be created as JohnDoe.storedprocedurename instead of dbo.storedprocedurename. Any help in this area is appreciated.

Dave

View 1 Replies View Related

How Can I Create A List Of Users Permissions Daily

Aug 16, 2004

I need to be able to set up a table listing users permissions, this needs to be run daily and then notify me of any changes without using the auditing or profiler software.


Any ideas?? :eek: :eek: :confused:

View 3 Replies View Related

How To Create Access Permissions For Remote Server

Jun 13, 2008

where can check for SQL Server service account write access permissions ??????

and if it don't has permission How can i set the write access permissin.

Thanks & Best Regards
Madhu

View 3 Replies View Related

User Permissions - Read Only With Create View

Jan 11, 2008

I need to create a new login with SELECT rights so the users can view all tables with no UPDATE, DELETE, OR INSERT rights. But this user needs to be able to CREATE VIEWS. I have assigned the user to the Public role and gone in and modified Securables for the Database to be able to CREATE VIEW. When I connect using my new user and try to create a view, I get the error message: CREATE VIEW permissions denied in database 'test01'.

Help Please

TMDavis

View 1 Replies View Related

Permissions Needed To Create A Shared Schedule?

Mar 10, 2008



I am setting up a role to allow certain users to create and maintain Shared Schedules in SSRS 2005. The tasks I have authorized are:
View reports
View folders
Manage all subscriptions
View data sources
Consume reports

What else do I need to grant? Right now the user cannot see the Site Settings link in order to get the the manage schedules.

Thanks,
Phill

View 1 Replies View Related

SQL Security :: Permissions To Create And Drop Tables?

Jul 31, 2015

what are the minimum permissions to allow a user to view, create, & drop tables within a DB (SQL 2008)?

View 4 Replies View Related

SQL 2012 :: SSAS Cube - Show Dimension Attributes For Only One Specific Fact Measure?

Aug 3, 2015

I have built a fact table and few dimension views in Datamart with the aim of creating a Cube.

On the Fact table I have added a CASE Statement with the following threshold for Premium due amounts:

CASE WHEN....
'Due_0-1_Month'
'Due_1-2_Month'
'Due_2-3_Month'
'Due_Over_3_Months'
'Overdue_0-1_Month'
'Overdue_1-3_Month'
'Overdue_3-6_Month'
'Overdue_Over_6_Months'
...END

I then created a Dimension to link this to:

CREATE VIEW...
Select 'Due_0-1_Month' as Ageing_Threshold
union all
Select 'Due_1-2_Month'
union all
Select 'Due_2-3_Month'

[Code] ....

I was successful in processing the cube, however the problem is everytime I drag the dimension on the columns field in Pivot tables the Thresholds start to break up the other amounts that I have on display like Acquisition Costs, Tax amounts. I am only interested in showing the breakdown of Premium amount measure by the Threshold dimension.

somehow 'Hide' or 'prevent' the Threshold dimension from breaking down the other measures on the Pivot and only breakdown the amounts for Premium?

how I should structure my tables in SQL or any MDX queries to resolve this.

View 0 Replies View Related

Permissions To See Server Logins/Create Database Users

Feb 2, 2007

Our company has 2 Database Roles (DBE and DBA). The DBE creates
database schema, performs SQL Server Administration, and manages server
security. The DBA writes data access, ETL, and manages database
security. In 2005, we're struggling with how to allow the DBA to see
all of the logins on the server in order to add them as users of their
database. What permissions does the DBA need to select from any of the
logins on the server to add them to their database?



Michelle

View 1 Replies View Related







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