Adding linked measures without rebuilding?

SQL Server Analysis Services

Index ‹ SQL Server

- Previous
  - 1
    - Log files grows indefinitely and causes ETL to fail Thanks Matt; Could you tell how can I reduce the number of events that's been logged Meaning- how can I turn it off Rok. Tag: Adding linked measures without rebuilding?
  - 2
    - SSIS - Best way to copy files from one directory to another I would use the File System Task rather than script. It would take two operations to do the move and then the rename. Your configuration would place the directory name in a variable. Above you indicate that you have multiple directory names. If so, I would specify these together as a comma-separated string, then use a script task to split that string into an array that can be iterated by a For Each loop. Once you have the directory name in a variable either directly from the configuration or from a ForEach iterator, you would do a ForEach to iterate the files in the directory. Hopefully all your files have the same extension since it will make constructing the new filename much easier. If so, only get the filename without the extension from the ForEach into another variable. With the directory variable, the filename variable, and a hard-coded extension you can create expression-based variables to generate the source and destination names for a rename operation. The "destination" or the rename would also be the "source" of the move (or vice versa if you choose to do the move first). Another variable will probably be set from the configuration for the move destination folder. If you can't hard-code the extension in your expression to generate the new filename, then the expression will be more complicated as you have to insert the date into the filename before the extension. Tag: Adding linked measures without rebuilding?
  - 3
    - MDX - Group By functionality Hello. I am currently trying to replicate a GROUP BY clause in MDX. Basically we have a Many-To-Many Dimension, with Planograms-Items as our hierarchy. When I say: { DESCENDANTS( [Planogram].[PLanogram1], [Planogram].[Items]), DESCENDANTS( [Planogram].[PLanogram2], [Planogram].[Items]) } I get duplicate items since an item is in both planograms, but of course each row has it own sales, units, etc. The problem is, when I submit larger queries I get 30,000 rows, 3,000 of which are unique Item ID's. I've tried a lot, SUM(), using STRTOMEMBER(), etc...but to no avail. Basically i'm looking to sum the rows in which the Item ID's are equal, and only get 3,000 rows back from the cube, with all the non description columns summed. ANy ideas Thanks a lot. Tag: Adding linked measures without rebuilding?
  - 4
    - SQL Server 2005 Profiler - Newbie question Profiler works good.. A new method exists in SQl 2005, in the system view sys.dm_db_index_usage_stats ... An example of it's usage would be this query. select top 500 db . name , obj . name , * from sys.dm_db_index_usage_stats ius inner join sys.databases db on ius . database_id = db . database_id inner join sys.objects obj on obj . object_id = ius . object_id This view is refreshed each time SQL Server is restarted... You COULD restart SQL, then moniotr this system view for usage info... or Profiler it... Bruce Tag: Adding linked measures without rebuilding?
  - 5
    - Parameterized connection string & parameters - problem Hi, I＊ve created a report which utilizes two stored procedures to populate parameter dropdown and fill report itself respectively. Report works fine until I create parameterized connection string. When datasource (not shared) has parameterized connection the parameter dropdown is greyed. I＊m getting error: ＆error during processing of the ConnectString expression of the datasouree ＆name＊＊. It works fine when I＊m using only one stored procedure (no parameter dropdown stored procedure is executed 每 report has only one dataset). It looks like adding second dataset to use datasource with parameterized string spoils something. Any advices are welcome. Tag: Adding linked measures without rebuilding?
  - 6
    - SQL Server 2005 Developer Ed Installation On Vista Business Ed 64 This sounds strange. When I have installed Sql 2005 on this Vista Machine and then applied SP2 it kills Vista to the point it wont even start in Safe Mode - It will come back when using Last Known Good Configuration but this leaves Sql Server without the SP2 and it doesnt run very well - Compatability issues and all. Tempted to go back to XP 64 where Sql 2005 ran without a hitch. Vista is a clean install - of course. Anybody got ideas PROBLEM SOLVED Tag: Adding linked measures without rebuilding?
  - 7
    - Script Task scripts will not stop at breakpoints. I was in the process of deleting my other post when you replied. I didn't want to post in a thread that had something marked as an answer. Yes, this is for script tasks. I certainly could use MsgBox() but that is hardly an answer to this problem. I could also write text out to a file, call a web service, insert a record into a table, etc. None of those things take the place of stepping through code. Is there a fix in the works for this issue It really makes script tasks of limited use, or at least it makes them take much longer to develop. Tag: Adding linked measures without rebuilding?
  - 8
    - Login failure issue with Crystal reports connecting to SQL Server 2005 What do you mean..."outside the application " It sounds like it's using impersonation or windows authentication. Please post your connection string without the login and password. Adam Tag: Adding linked measures without rebuilding?
  - 9
    - Parse XML to load files inside them Thanks for the quick reply JayH will try n let it out Tag: Adding linked measures without rebuilding?
  - 10
    - Browsing attributes from shared dimensions Hello, e.g : I have the dimensions order.date , delivery.date based on the dimension date. When i browse the date dimension in the cube browser or in excel, and i select the year attribute from the dimensions it just shows year in the browser and I really want it to show order.year and delivery.year Our real cube has more than 10 shared time dimensions, so it can be really confusing to users when they are browsing , does anyone has an answer Regards, Wout Tag: Adding linked measures without rebuilding?
  - 11
    - Cannot connect to SQL Server 2005 Express with Management Studio Express Can you ping \\MPLIAM Try usingthe IP address rather than the server name. Tag: Adding linked measures without rebuilding?
  - 12
    - password cannot be saved Thanks. Do you mean I need another password to open my package Where can I set the "ProtectionLevel" in the package Tag: Adding linked measures without rebuilding?
  - 13
    - Unable to change SQL 2005 database Autogrowth through Server Management Studio Hi Akinja, So far the highest number I could input is 10000 for % of growth. Anything higher is automatically converted to 10000 when validation occurs. I'm following some other hunches as to how this number is getting set to something so high. Will let you know what I find out in the next few days. Terrence Nevins SQL Server Program Manager Tag: Adding linked measures without rebuilding?
  - 14
    - Sorted Input Matt David wrote: This is actually by design. The layout code will check to see if you are seeing the input as sorted and return that information to you instead of the actual values that are on the upstream columns. I think this is best seen with an example. Say you have data from upstream sorted on ColumA (1) and ColumnB (2). If you mark that both columns are used (via SetUsageType) then you will get those SKP values and the IsSorted property will be true. However, if ColumnA is marked as ignored (not used) then the layout will see that you are not using the sorted column so to you the data is not sorted and, therefore, the layout will return that IsSorted is false. If, on the other hand, you had ColumnA as RO or RW (used) and ColumnB as ignored then you would get that IsSorted was true because you are looking at a column that does make the data seem sorted to you. This is also why the virtual input shows the SKPs. It is because all the columns are available so the data would be sorted while using those columns. HTH, Matt Hi Matt, Hopefully you're still getting Alerts on updates to this thread. If I read what you said above correctly, I need to check the virtual input in order to know for sure that the input is sorted. Is that correct Darren, how did you get round this problem I need to check that the input is sorted without the user having to select all the columns. Regards Jamie Tag: Adding linked measures without rebuilding?
  - 15
    - Need to change Authentication type of my first DB in SQL05 Sql service is necessary after changing the authentication mode on server level. Hence do a restart after changing the authentication mode. Tag: Adding linked measures without rebuilding?
  - 16
    - While creating a snapshot... I traced the processes and I concluded that there is a problem with the "percent" User-Defined Data Type. It' s defined as "Tinyint" and it's length is 1. I observed that only the tables which has a column which is defined as "percent", causes this error. Why do you think I faced a problem like this And do you guys think my conclusion is correct I'll contact with the software company in case I think this User-Defined Data Type is exactly the problem. Tag: Adding linked measures without rebuilding?
- Next
  - 1
    - How to export to a fixed width flat text file with row delimiters? To make this work so that each row is exactly the same length, you may need to add a zero length column as the last one in the connection manager, and set the row delimiter on that one. Tag: Adding linked measures without rebuilding?
  - 2
    - error running ssis package it looks like a timeout issue also to me. when i remove a very big table from this package (a 40 milion records table) the package run faster and finish successfully. how can i set the timeout of the connection in the BIDS . i didn't see timeout property in the connections manager. anyway, i dont understand this SSIS. in sql2000 i transferred very large tables with no problem using the dts. since i upgraded to sql2005 i encounter lots of bugs in the SSIS. Thanks. Tag: Adding linked measures without rebuilding?
  - 3
    - Recursive Multi-Level Query using CTE. Attn: Experts! Agreed, the 2 had me a bit confused too :). Also, can you provide a table structure with insert statements so we don't have to (not you Kent :) Tag: Adding linked measures without rebuilding?
  - 4
    - Need urgent help on Aggregate Function Thanks for asking this question. I think i made a mistake by leaving the parent hierarchy as default "Measure" and Parent Member as empty. I have modifed the Parent hirerachy to Channel.Channel and Parent Member to Channel.All Channels. I am processing the cube now and would get back to you soon with the results. Thanks once again Tag: Adding linked measures without rebuilding?
  - 5
    - Problem: Formatting The Sql Report For more complex layout scenarios e.g. mixture of tables, charts, matrices etc. place whatever objects you want to have repeated in a list control and group the list control by the paging field. this works as long as the data is coming from 1 dataset Tag: Adding linked measures without rebuilding?
  - 6
    - Guidelines for choosing collation Looks like BIN2 is a way to go. Tag: Adding linked measures without rebuilding?
  - 7
    - SQL Server 2005 Install fails on Vista Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Professional (Build 6000) Time : Thu Feb 22 16:13:56 2007 JAZZ : Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online. JAZZ : Setup has detected a problem with Microsoft .Net Framework installation and cannot proceed. Microsoft .Net Framework 2.0 is either not installed on this system or is corrupt. SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt. Time : Thu Feb 22 16:14:06 2007 List of log files: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_JAZZ_Core(Local).log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_JAZZ_Datastore.xml C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_JAZZ_.NET Framework 2.0.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_JAZZ_Core.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_JAZZ_.NET Framework 2.0 LangPack.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_JAZZ_.NET Framework Upgrade Advisor.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_JAZZ_.NET Framework Upgrade Advisor LangPack.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_JAZZ_.NET Framework Windows Installer.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_JAZZ_.NET Framework Windows Installer LangPack.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_JAZZ_Support.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_JAZZ_SCC.log Tag: Adding linked measures without rebuilding?
  - 8
    - New features of Reporting Service in SQL 2008 Forgive me, but what is BOL I'm trying to find answers to this as well. Thanks! Michael Tag: Adding linked measures without rebuilding?
  - 9
    - roll back in for each container thanks jamie.. Is there anyway to roll back all the records inserted from the flat file. or can we trim all the inserted record from the delimited to avoid repeattion of the data in database while running the file again after correction Tom Tag: Adding linked measures without rebuilding?
  - 10
    - SSRS 2005 probplem with mdx prameter passsing i need to knw how the parameter should pass to this query. Tag: Adding linked measures without rebuilding?
  - 11
    - SSIS SCript Transform Parallelism Thanks for your reply. Could you please leaborate on how it would be best to solve the above problem Regards, Tirthankar Tag: Adding linked measures without rebuilding?
  - 12
    - SQL Server Express authentication mode greyed out Jens K. Suessmeyer wrote: I Hi Tim, I guess that you didn＊t connect with a server principal (user) which has the appropiate permissions to change the authentication type. Dont worry about the message " Login failed for user 'sa'.The user is not associated with a trusted SQL Server connection", this is dedicated to the fact that you only have Windows authentication enabled. SQL Server won＊t accept any SQL Server logins then (even if it is sa). If you don＊t have any Windows User on hand which is priviledged to change the authentication mode (normally and by default the (Windows) group "Administrators" (and all users assigned to that group) are system administrators at Sql Server level) you can switch the authentication mode in the registry. http://support.microsoft.com/kb/322336/en-us Make sure you restart the service after doing that. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- Hi I have the same problem I try to swith the authentication mode as http://support.microsoft.com/kb/322336/en-us said, but im trying the first step in the prompt I write: osql -U sa password: & the prompt display "Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\TAVO.NATALIA>osql -U sa Password: [SQL Native Client]VIA Provider: The specified module could not be found. [SQL Native Client]Login timeout expired [SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. C:\Documents and Settings\TAVO.NATALIA>" I already check start->SQL Server 2005 Surface Area Configuration->Area configuration for services & connections->SQL EXPRESS->DATABASE ENGINE->Remote connections I have select: Local and remote connections -> using both TCP/IP and named pipes So whats the problem thnx Tag: Adding linked measures without rebuilding?
  - 13
    - how to call a stored procedure in SSIS "Oledb command" Source executes stored procedures.But it does not recognize the output of the stored procedure. If I have a select statement at the end of the Stored procedure that returns me some columns,then those columns are not recognized by "OLEDB Command" as out put columns. Is there any advice for executing such stored procedure Tag: Adding linked measures without rebuilding?
  - 14
    - change the background color in table in report thank you Tag: Adding linked measures without rebuilding?
  - 15
    - WebRequest over HTTPS fails under SQLCLR, but works elsewhere This might not answer your question, in that in my case even regular http traffic didn't work from SQL CLR. Turned out the answer was to set the proxy for the webrequest in the C# code. For some reason this wasn't necessary when running under Visual Studio (I guess it uses the IE settings or something). Since your problem is only SSL releated, I guess it's a certificate problem. On several occations (with Java) I've had to update the root certificate for the virtual machine. Maybe the SQL CLR has separate copies of certificates (for the Certificate Authorities) from the windows CLR, and this is why it works when run as a winform app. Tag: Adding linked measures without rebuilding?
  - 16
    - Table design question - subject matter expert database It doesn't make sense to have three separate tables for your SMEs. Just create ONE SME table. In fact, you may wish to consider rolling the SME and SO tables together, adding a flag column to indicate 'Owner'. (An 'owner' may also be an SME.) Reduces and simplifies the JOINs required. (Or add an 'Owner' field to the Subject table.) Tag: Adding linked measures without rebuilding?

jyhd

Is it possible to added a linked measure group without having to rebuild the base cube Or, is it possible to build a cube that exists of nothing but linked measures

Re: Adding linked measures without rebuilding?

Adrian Dumitrascu

> is it possible to build a cube that exists of nothing but linked measures

Yes, you can have a cube that contains only linked measure groups. This would be the equivalent of a virtual cube from AS2000.

> Is it possible to added a linked measure group without having to rebuild the base cube

If the cube has other measure groups (with partitions and maybe aggregations built), you don't need to re-process them after you add a new measure group (linked or not).

Adrian Dumitrascu

Re: Adding linked measures without rebuilding?

jyhd

>If the cube has other measure groups (with partitions and maybe aggregations built), you don't need to re-process them >after you add a new measure group (linked or not).

Don't I have to do some sort of processing to push out the new measures to the cube