How To Create A KPI In SSAS 2005
Jan 6, 2008We need to create a KPI in SSAS 2005 and the same needs to be display in the dashboard.
Can any one help me how to Create a KPI and how can i bring that values to the ASPX screen.
ADVERTISEMENT
Analysis :: How To Create Parallel Period For Multiple Measures In SSAS 2012
Mar 27, 2012I am trying to create a calculated member for parallel period function using ssas 2012. I have 10 measures for which i need to create parallelperiod.Â
I can successfully create for 1 measure but when i add multiple values to it it breaks. Below is the sample i tried for multiple measures:
sum(ParallelPeriod([Date].[Calendar].[year],1,[Date].[Calendar].currentmember) ,
([Measures].[Revenue],[Measures].[Expenses]))
Does SQL 2005 Come With SSIS, SSRS, SSAS, BIDS, VS 2005?
Dec 4, 2007
Hi everybody.
I'm looking to upgrade to SQL Server 2005 (Standard Edition). I'm interested in using SSIS, SSRS and SSAS. I hear that BIDS runs inside of Visual Studio 2005, and comes with the SQL 2005 software. I currently have VS 2003. My question is: Do I need to purchase anything besides SQL Server 2005 Standard, or do I need to buy anything separately, like VS 2005? (if so, which version would you recommend?)
Thank you very much!
- Trevor
SSAS 2005 Connection String
Mar 20, 2007i am trying to connect to ssas 2005 -- i can get to it through management studio no problem. i cant seem to get my program to connect
can anyone see anything wrong with this connection string
Provider=MSOLAP;User ID=myid;Password=mypass;Data Source=mysrvr;Initial Catalog=mycat;Client Cache Size=25;Auto Synch Period=10000;
SSAS 2005 Service Dies - HELP!
Apr 11, 2007When processing my very large cube, after 6 hours, the service dies and the ASCMD returns an error saying it can't find the server / service. The rest of the server is fine and I just have to restart the Service. But the ASCMD keeps killing the service. Can anyone offer some ideas of when I should be looking?
Windows Server 2003 SP1
4GB RAM
4 CPU
Many thanks in advance,
Richard.
SSAS 2005 SQL Query Urgently Help !!
Aug 13, 2007Hi, I'm building a SSAS Integration project, it consist of extracting data from a Microsoft Access 2003 database and consolidate data into a SQL Server 2005 database for datawarehousing.
I need to make several operations for integration, but i'm struck in the following:
- I added an Ole DB Origin that connects to my access database
- I made an sql query with multiple joins that extract all data i need for first instance.
- in data i extracted, i got one column named: FECHA (and many other colums), it contains data of the date of the actual sale; but in previous steps i fill a table named DimTiempo from my sql server database that contanins all the dates (with no repeating) of the sales and added an unique primary key for them; so, now i need to get that primary key for each column FECHA i gotted in my sql query in OLEDB ORIGIN, for example:
I have: 20/20/2004 (column FECHA on my OLEDB ORIGIN gotted with an sql query with multiple joins)
I need: 001 (extracted from DimTiempo, its the primary key of the registry 001 - 20/20/2004)
I need that code or primary key to insert into my new table on my sql server database because its related directly with my DimTiempo table filled previously.
For more directions, i don't have that primary key column on the original access data base; i reestructure completely the database on sql server to make the datawarehouse work fine.
Please, i hope you help me, tell me what do i need to do to get all the data to fill my sql server 2005 database.
Thanks.
SQL Server 2005 SSAS - Refresh Cube
Nov 12, 2007Hi 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
SSRS && SSAS 2005 Data Parameter
Aug 20, 2007
Hi all,
I'm sure what I am trying to do is very simple - but I just can't seem to figure it out. I have a report based on a SSAS cube (SQL 2005). The report shows sales based on the dates the user selects from the parameter field (the date parameter field comes from a Y-Q-M-D hierarchy). This all works fine.
What I would like to happen is for the members within the last 3 months to be automatically selected so that the report automatically executes for the last 3 months.
Can anyone help or offer any advice. If possible I would like to achieve this using the GUI features so that power users can use the "plug and pray interface".
Many thanks
Matt
How To Become A SQL 2005 SSIS And SSAS Certified Profession? Where To Start?
Jun 26, 2007I am very keen to go into the BI area with SQL 2005, somebody suggested me to go more specialized in SSIS and SSAS. I heard there is a certified programme in BI track which was just launched last year by Microsoft, but I couldn't find the info anymore, could anybody here help providing some information for me to get started?
I do not have any MCSE yet. Is there a need to get some basic MCSE before jumping into the BI track?
Thanks a lot!
Can A SAS PMML 2.1 Compliant Model Be Imported Into SSAS 2005?
Mar 3, 2008Is it possible to import an SAS PMML 2.1 compliant neural network model directly into SSAS 2005?
Are there other or all SSAS models (e.g. Decision Trees) that can be created from an imported SAS PMML 2.1 compliant source?
Report Model Security Integration With SSAS 2005
Aug 7, 2006Hi,
I have a question here for report model generated on top of SSAS 2005. If security has been defined in SSAS 2005 cube where RoleA only have access to certain dimension, is this security setting integrated with the report model and propogate down to the report builder when used where RoleA users have no access to dimension allowed?
Thanks,
J Lim
Best Practices SQL Server 2005, SSRS, SSAS, SSIS Setup
Oct 8, 2007I would like to know best practices for setting up my environment. To date, I've had everything running on a single server. That would include the database engine, SSIS, SSAS and SSRS. The box configuration is dual hyperthreaded 3.6GHz Xenon with 4GB of RAM on Windows Server 2003. I just received a much larger server and want to configure it to maximize our environment. The new box contains four 2.6GHz Quad Core processors with 16GB of RAM. I would like to know if I should split the ETL and database engine from SSAS and SSRS, or should this box have enough horse power to house it all and use my other box as a dev environment. Also, we are planning to purchase Performance Point 2007 primarily for PAS and Scorecard Manager so please take that into consideration as well. Any comments are greatly appreciated.
Thanks.
SSRS 2005 V SSAS 2000 Mutli-Select Parameters
Nov 2, 2007Has anyone managed to crack getting multi-select parameters to work from an SSRS 2005 report which is querying an SSAS 2000 cube.
SSRS 2005 does support Multiselect, however SSRS 2000 did not. Given that i am querying an SSAS 2000 cube, i get the impression that i am also limited to SSRS 2000 functionality regarding to multi-select parameters.
Is there anyone out there that ever managed to get a wor around, say by using filters on a table or anything really that coud simulate the same behaviour....
Problem With Forecasting With Excel 2007 DM Add-in Using Drill-through Data From SSAS 2005!
Sep 18, 2007
I€™m having a problem with Excel 2007 DM and SQL 2005 and I hope someone out there has a solution.
Consider the following environment:
Windows XP SP2 or Windows Vista, Excel 2007, Data Mining Add-in, SSAS 2005 (with session mining models enabled, an AdventureWorksDW cube deployed and drill-through actions available).
Now take the following steps:
1. In Excel 2007 set up a connection to SSAS
2. Connect to the cube and create a new pivot table report (drag and drop whatever you like)
3. Right-click on one of the cell values in the data region and either select a drill-through action, or, select Show Details in the context menu
4. Ensure that you have at least 10 detailed records that are generated on a new worksheet page; you should have a time-based column in your detailed records
5. Select the table of detailed data, then select the Analyze tab (within the Table Tools grouping) which appears in the topmost menu above the ribbon
6. Click the Forecast button in the ribbon and choose both the field which you want to predict as well as the time-based column (from step 4) as well as the number of time periods to forecast
7. Finally click OK.
1. Having followed these steps on both WinXP SP2 and Vista, I keep coming across the exception: HResult:0x800A03EC. Any ideas as to why this exception pops up? If I was using a normal table of data (which was not generated from a Show Details or drill-through action), then the Forecast button works fine.
I googled it and thought the localization settings for SSAS 2005 and Excel 2007 needed to be the same (initially they weren€™t). I€™ve tried removing the auto-filters which appear atop each column in the detailed data table prior to clicking the Forecast button, and, I€™ve also tested for a series of data across a number of time periods with the same result.
Also, a colleague of mine discovered that the column headers that appear by default from a drill-through start with "$[", and, in removing them the Forecast function appears to work.
I would have thought there would be a seamless transition in Excel 2007 between data retrieved from a cube and the DM Add-in featueres (or at the very least, a more meaningful exception message than the one presented).
Is there something I€™ve missed, or, is there a KB article I haven€™t come across yet? As I know for a fact that the problem is reproducible, is there a fix to this problem on its way to us? Is there a useful workaround that doesn't require manual intervention?
Thanks,
A.
What Version Of SQL Server To Choose In Order To Develop SSAS, SSIS And SSRS 2005 Projects On Xpsp2?
Oct 27, 2007
Good day community. I have a question about SQL Server 2005 Anywhere edition which i currently installed on my desktop. Does it fit my needs which stated on the subject? If no, what should i select for my projects?
How To Create A Job In Sql Server 2005
May 21, 2008Hi All,I need to create a job which executes the update query based on a condition i.e., duration between two dates. How shall i create and use that job.Please can anyone help me.Thanks in advance Regards,Praveen
View 3 Replies View RelatedCannot Create Diagram In SQL 2005
Nov 29, 2006i get the following message
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
I am the db owner but still wouldnt let me install and create diagrams.
help!
cheers
How To Create , Save DTS In SQL 2005
May 30, 2007Can anyone tell me what all steps in creating DTS package , how it saves,
how it re executes... what all steps ... and how it makes??
Thanks
Aravind
How To Create A DTS Package In 2005
Jan 23, 2006Can anyone give me a quick tutorial on how to create a DTS package in 2005 using Business intelligense studio.
I want to import a file from a ftp location and load it into the database as a table.
I know how to do it in 2000, but can use some help in 2005.
thanks
How Do I Create A New Db In Sql 2005 Express
Jan 30, 2006How do I create a new db in sql 2005 express useing manager express? I'm used to mySql front and this is my first try at sql.
Also, does anyone know of a link(s) on the vast msdn website that explains how to use this software? All I've found so far, are a lot of pages telling what it can do not how to do it.
I'd appreceate any help, I want to get started on this .
Create View On Sql 7 From Sql 2005
May 13, 2007hi
i need to create view in sql 2005 db from table in sql 7 db
when i try to connect to the sql server i get this messeg:
This version of Microsoft SQL Server Management Studio can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (ConnectionDlg)
there is away to resolve this problam?
yaakov
How Can I Create A New Instance Under SQL 2005?
Aug 10, 2006I have a clean SQL 2005 install, and would like to setup a new/empty instance for an application suite (3rd party) to reside in.
Is there any way to do this?
How To Create A DTS Package In 2005
Aug 15, 2006I am 100% new to SQL. I have used Access for ever. I need to know how to take a Access 2003 database and covert it over to SQL 2005. I have no idea how to complete this. I was told to do a DTS package but I do not see any options for this.
Any help would be great!
Thank you
Sql Server 2005 - How To Create Scheduled Job
Jul 25, 2006We just installed SQL Server 2005. I have 3 jobs within SQL Server 2000 that i would like to import into the new server howeber i have no clue on how to achieve this. In fact I dont even know how to make a new job within SQL Server 2005 at all? Can someone please give me the steps on how to do this.
BTW the old job accesses launches a .EXE application every day, once a day at 5pm and the other job launches the same applicationb but at 5am. I had to have 2 seperate jobs because I couldnt figure out how to pass a different parameter for the two launches.
Thanks.
How Do I Create A SQL 2005 Database From A SQL 2000
Aug 23, 2007I have a SQL 2000 database on one server that I'm trying to transfer to a new server. The new server has Small Business Server R2 Premium Edition, which includes SQL 2005.
I tried to transfer the database in the normal way that I'd create a copy database, which was: -1. Backup the source database2. Create a new database (empty) in the new server3. Restore to this database from the backup taken in #1.
Of course on previous occasions I wasn't changing version, but I expected that this would either fail immediately (message "incorrect version" or some such), or else work.
At first this appeared to transfer OK. It took about 20 minutes to create the backup (just over 5GB), and about the same time to restore it. The restore terminated with a message "Database has been restored successfully"). However, the database's icon in Management Studio's Object explorer showed a little up arrow, and alongside the database name "(restoring ....)". Clicking on the database icon did not expand it. 3 hours later it still was like this. Examining the server showed zero activity.
I expect that it's failed, and I should delete the new "(restoring...)" database and start again. How should I create this SQL 2005 database?
How Do I Create A New Instance Of SQL Server 2005
Nov 27, 2007I have access to a server with sql server 2005 workgroup edition. It runs an instance of sql server for this huge application we use. I would like to create a new instance of Sql server 2005 so I can play around with it and learn how to use the 2005 version. How can you create a new instance? I want this instance to run alongside the current instance. I can't find out how to do this anywhere. I'm sure it's possible though. Thanks
View 3 Replies View RelatedHow To Create Invisible Table In 2005?
May 6, 2008Hi,
Can I create invisible table in SQL Server 2005?
Access(all versions) has this option if you add Usys_TableName.
The table will be invisible, but you can get data from it
Mark
Can't Create A SQL Server 2005 Database
Feb 20, 2006I have installed SQL server 2005 on win xp. (SQL Server 2000 is also running)
My problem is that I can only create a database with compatibility mode of 70 or 80 (SS 2000) and not 90 (2005).
What do I do?
Cannot Create Databases On SQL Express 2005
Aug 9, 2006Help me please!
I've installed SQL Express 2005 on my XP. I'm trying to create a database but I keep getting the error no matter what I do.
Msg 1802, Level 16, State 4, Server MYCOMPUTERSQLSERV, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Msg 5123, Level 16, State 1, Server MYCOMPUTERSQLSERV, Line 1
CREATE FILE encountered operating system error 5(error not found) while attempting to open or create the physical file 'C:Program FilesExos9300DatabaseExos93.mdf'.
How To Create Cube In SQL Server2000/2005
Nov 1, 2007I 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
Create Assembly On Sql 2005 Sp1 Problem
Sep 15, 2006Hello ,
when I try to create an assembly on SQL2005
Create assembly LibSql
FROM 'c:SQLNETLIBSQLLIBSQL.dll'
WITH PERMISSION_SET = External_Access
I got the following error:
Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x80131522. You need to restart SQL server to use CLR integration features.
Configuration:
Server: 8 processors with 16 GB RAM
select @@version returns:
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
AWE configuration is enabled.
CLR is enabled
Server was upgreaded from sql 2000 SP3a
Restart of Sql doesn't help
Thank you for your advice.
artek
Create View Errors In SQL 2005
Oct 24, 2007We have a script that drops the views on all the database tables and then creates them as part of version update of the database. For instance:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPONSOR_SYSTEM_TD]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[SPONSOR_SYSTEM_TD]
GO
CREATE VIEW dbo.SPONSOR_SYSTEM_TD AS SELECT sponsor_installation_type_code,install_directory,sponsor_version,data_directory,system_install_text,record_status_code,mod_date_time,mod_login_id,create_date_time,create_login_id,replicate_to_server_flag,Sponsor_ID FROM SPONSOR_SYSTEM
GO
This above code is done for all 120 tables and has worked fine until now. All our clients have been using SQL 2000. Now we are getting clients with SQL 2005.
The problem is that for these clients using SQL 2005 on 20 of the tables we get the error:
Could not resolve expression for schemabound object or constraint.
And the View is not made for these tables. I saw where this could because the server and database collation is differemt but in this case it's the same for both. I can't see any differences so far between the tables that a View was successfully made for and the ones that it wasn't.
What else should I be looking for that would give this error?
Thanks
Create .sdf From Existing SQL Server 2005 DB
Aug 22, 2007Hello ,
1.Is there a way to generate an .sdf (SQL CE DB) from an existing SQL Server 2005 DB?
So that the sdf file has the same tables and data as SQL server 2005 DB.
2.Is there a way to copy data in Excel file to an .sdf file (SQL CE DB)?
Thanks,
Rookie