Loading only the newest facts into a cube (Delta)

SQL Server Analysis Services

Index ‹ SQL Server

- Previous
  - 1
    - Can SubReports be from SubProjects in the same solution I'm not sure it's going to work that way -- somebody else will have to confirm, not really my area -- but, if it does not, could you create a custom post-build step that copied the RDLs from their source folders to where they needed to go within each individual project I realize it's not ideal to replicate the files, but this would keep them up to date/synched. >L< Tag: Loading only the newest facts into a cube (Delta)
  - 2
    - Report Wizard - No 'Next' button highlighted on last screen Hi, I am trying to use the report wizard and I get to the last screen where it asks for a name for the report file. The 'Next' button is not unprotected although the 'Finish' button is. As far as I can tell I have setup the Matrix style report up correctly. If I use the 'Finish' button, Visual Studio just crashes. The help does not give any clue and I have not found any answers in the forum. Any ideas what the problem might be Tag: Loading only the newest facts into a cube (Delta)
  - 3
    - Default Parameters Not being set Hi there, What is the default value you are trying to set Did you try to go to the Properties page of the report in Report Manager and set the parameter there Sometimes I noticed that you have to delete the report before deploying if it already exists on the report server. cheers, Andrew Tag: Loading only the newest facts into a cube (Delta)
  - 4
    - Convert string to datetime - Performance Probably just a matter of opinion. SSIS can do datatype conversions, but has to create a new column in the pipeline to hold the new type, which is a little bit inefficient. I generally don't like things "hidden" in the OLE DB Source, but in this case I think that's what I'd do. Tag: Loading only the newest facts into a cube (Delta)
  - 5
    - Does MS know SQL2005 query performance is slower than SQL2000? did you clear the proc cache before running the procedures Running the commands below will ensure that you are running both sprocs on common ground: DBCC DROPCLEANBUFFERS DBCC FREEPROCCACHE Also, you can't always go by the time it takes to run a query. You really need to compare the logical reads returned by running the command SET STATISTICS IO ON before you run the statements to compare the reads. If your reads are drastically different, something may be funky. Tim Tag: Loading only the newest facts into a cube (Delta)
  - 6
    - View vs Function Followup Question I guess one difference would be the inability to use non-deterministic functions in UDFs. However, i guess thats not really the answer you're looking for! ;-) It is a great question. Be interested to hear others views. Tag: Loading only the newest facts into a cube (Delta)
  - 7
    - Auto Filter in 2005 Reporting Services Hi, Reporting Services does not have the possibilities to do this. I think that according what you listed above you need to use a cube in case of reporting services. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog Tag: Loading only the newest facts into a cube (Delta)
  - 8
    - System credentials Actually I think there is a little bit of confussion between CREDENTIALS and CERTIFICATES. The items you described are principals mapped to certificates, these principals are used to grant permissions (via digital signature) to system resources. For example: SELECT * from sys.server_permissions where grantee_principal_id = suser_id ( '##MS_SQLResourceSigningCertificate##' ) Should return กฐVIEW ANY DEFINITIONกฑ permission granted to this principal. I would recommend the following topics from BOL: กค Module Signing http://msdn2.microsoft.com/en-us/library/ms345102.aspx กค Credentials http://msdn2.microsoft.com/en-us/library/ms161950.aspx As well as the following blogs: กค http://blogs.msdn.com/lcris กค http://blogs.msdn.com/raulga I hope this information helps to clarify this topic; let us know if you have any further questions. Thanks a lot, -Raul Garcia SDE/T SQL Server Engine Tag: Loading only the newest facts into a cube (Delta)
  - 9
    - 3 questions about certificate 1. Yes, both a public key and a private key will be created as a result of that statement. 2. The algorithm is RSA. 3. The private key is stored in the database, encrypted by the password you specified. It's not visible through normal catalog queries. I don't understand your last question: there is a single private key, so that's the one you're using for decryption. Thanks Laurentiu Tag: Loading only the newest facts into a cube (Delta)
  - 10
    - Instead of INSERT trigger!! Just remove every "ELSE" and you should be fine. (except for the last one) Adamus Tag: Loading only the newest facts into a cube (Delta)
  - 11
    - How to update,delete,insert the data into xml column for xml file You are using the right command, i.e. the modify method in xquery. The problem now is the xml is not valilid against the schema after you delele the elements. Check the schema for the xml column. If the deletion is required, you may need to change your xml schema definition. Tag: Loading only the newest facts into a cube (Delta)
  - 12
    - Login failed for user '(null)' Resolved. The problem was in two places: I had to remove Anonymous access from the directory in ISS (ISS/Directory/Properties/Directory Security/Edit) and change the login in the SQL Server service from Local Account to my login information (Start/Run/Services.msc/MSSQLSERVER/Log On/This Account). These changes allowed the link server to recognize and authenticate the login. Tag: Loading only the newest facts into a cube (Delta)
  - 13
    - Asterix not showing in report details to clarify are you saying: you have a value in the database that contains the text "** blah blah **" when you run the report, only "blah blah" is rendered in the row and not "** blah blah **" Tag: Loading only the newest facts into a cube (Delta)
  - 14
    - i want send all kind of phones arround world So, you want us to help you send spam to our phones Perhaps a better explanition of your problem is in order. Tag: Loading only the newest facts into a cube (Delta)
  - 15
    - Need Alternative hmm do you have to option to change the contents of the .txt or .csv file are you just trying to insert the record to a table from that data source Tag: Loading only the newest facts into a cube (Delta)
  - 16
    - Calculated members Joshker Simply open SQL Server Management Studio Connect to Analysis Services Browse your Cube Now some measures and Dimension Drag and Drop in Row,Column and Data area. Now Right Click any where in Data Area. And then Click on Command and Options Then select check boxes Title Bar and Toolbar Now you will see Pivot Table Title Bar and Toolbar. Then you will see there Calculator Icon Simply Click on Calculated Totals and Fields Now here you should give Calculation Name and make you formula and press Change. These were the steps how to create Calculations on Pivot Tables for OLAP. Bhudev Tag: Loading only the newest facts into a cube (Delta)
- Next
  - 1
    - cant use replication sql server 2005 express edition only supports as subscriber... May either you have connected to express edition sql server or ssms express may not support... You may need to install regular client components from EE/SE/DE edtions cd... Check the following link for SQL Server 2005 Features Comparison... http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx Tag: Loading only the newest facts into a cube (Delta)
  - 2
    - ms works does not open MS Works YOu are in the SQL Server forum You should better post your question on any other public forum concerning MS Works. Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: Loading only the newest facts into a cube (Delta)
  - 3
    - Encryption and query performance See the following links - they discuss this issue in detail: http://blogs.msdn.com/lcris/archive/2005/12/22/506931.aspx http://blogs.msdn.com/raulga/archive/2006/03/11/549754.aspx Thanks Laurentiu Tag: Loading only the newest facts into a cube (Delta)
  - 4
    - Inserting CSV Files into SQL database Could you provide examples of any error messages that are being returned Thanks Chris Tag: Loading only the newest facts into a cube (Delta)
  - 5
    - Report Viewer to Get Data from RS Deployed on separate Network. I am afraid you won't like the answer but the Report Viewer control assumes a direct connection to the Report Server web service. It looks like in your situation, you need to install RS on the application server. A split deployment scenario is also an option (RS middle tier on the application server, while the catalog is on the database server) but you will need two licenses. Finally, in case you wan't to get innovative, try implementing an HttpHandler on the application server that would intercept SOAP and URL requests generated by the ReportViewer and forward them to the database server. I haven't done this but it should be possible. If you decide to try the last option, please post your findings here. Tag: Loading only the newest facts into a cube (Delta)
  - 6
    - Error while performing Fullbackup after a filegroup restore. I assume that you did a backup and restore of the CUSTBilling file group Did you ensure that the filegroup is back online after the restore completed Tag: Loading only the newest facts into a cube (Delta)
  - 7
    - Create an email link within the report... Hi Will - Yes, you can use expressions to build "mailto:" URLs, and set these for the "jump to" value in the navigation tab for the field properties. Tag: Loading only the newest facts into a cube (Delta)
  - 8
    - After SQL 2005 SP2, Query to Apartment Linked Servers fails We are having exact same problem Msg 7308, Level 16, State 1, Line 1 OLE DB provider 'xxxx.xxxxxx' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode. Does anyone have any idea on how to solve this toby Tag: Loading only the newest facts into a cube (Delta)
  - 9
    - Cannot construct a SELECT DISTINT COUNT... statement in SSCE 3.1 Hi Shalan, Nested queries are not supported in SSCE 3.1. They are in 3.5 Beta 2 though. Cheers Jeff Tag: Loading only the newest facts into a cube (Delta)
  - 10
    - SQL table design Welcome BeaverMan! Primary keys are extremely important. In most cases it is an Integer ID, although sometimes it is a string. The best thing I can suggest is that when you are making a new table, have the primary field entered first, then set this to be the primary key. That way you dont forget and wont have to go back to it when you realise that your app is erroring on an insert/update/delete as there is no primary key. hth Barry Andrew Tag: Loading only the newest facts into a cube (Delta)
  - 11
    - Bulk Inserting Data into a new table with different ID's that need to be changed Carel: What is the objective here; I am afraid I missed it. Tag: Loading only the newest facts into a cube (Delta)
  - 12
    - Multiple tables in dataset. SELECT * FROM TableA Unfortunately, the way these table are set up, you'll have explicity determine the table. ...or you could always loop through each entry for TableList. Adamus Tag: Loading only the newest facts into a cube (Delta)
  - 13
    - How can I determine the size of a database? In SQL Management Studio right click on data of interest and select properties on the context menu. Also, right click on database select reports/standard reports/diskusage from context menu. Tag: Loading only the newest facts into a cube (Delta)
  - 14
    - System Time is Wrong Hi Ceje, Do you use log shipping, replication What time zone is your server in. When you do change the time, please ensure that time and time zone are both set correctly. You will need to change it at the OS level. To start with you will need to watch out for columns that use getdate() in the primary key. After the time change, restoring the logs should be fine as its the LSNs that needs to be in order, the time of backups should not matter. Not sure if you use time based method to restore, you might need to restore the logs manually for 12 hours or something. regards Jag Tag: Loading only the newest facts into a cube (Delta)
  - 15
    - Moving from 2000 to 2005: issue Accessing cursor returned by sp Please post an example so we can test it out and give you guidance. I would suggest that you probably ought to rewrite the code to not use a cursor if you can, as cursors are not great for performance, and in triggers they are really bad for that. Louis Tag: Loading only the newest facts into a cube (Delta)
  - 16
    - SQL: How to Add a column with a default value in ONE query? Code Snippet create table #what (x int) alter table #what add y integer default(0) insert into #what(x) select 2 select * from #what /* x y ----------- ----------- 2 0 */ Tag: Loading only the newest facts into a cube (Delta)

ccote

HI, if I only want to load the delta of the rows that are in a refreshed fact table and the cube, do I need to create a partition in the measure groups Lets say that the rolap DW have been refreshed with today's data and my cube contains only yesterday's data, I do not want to do a full process. I want to process only today's rows using a time stamp in order to get the latest rows. How should I do it in SSAS 2005 Can I issue a process update only for the measure group

Thank you,

Ccote

Re: Loading only the newest facts into a cube (Delta)

Van Dieu Thai

You can perform a "Process Incremental" and then specify a SQL table or a SQL query to read only the new rows of data that you want to add to your cube.

Van Dieu

Re: Loading only the newest facts into a cube (Delta)

ccote

HI, will it process my dimensions fully and only the facts (measure groups) incrementally

Thank you for your help!

Ccote

Re: Loading only the newest facts into a cube (Delta)

Yongli Yang

If you don't want to touch your dimension, you could update your specific partition (which will include your new rows) only.