inflation factor in Analysis Services 2005

SQL Server Analysis Services

Index ‹ SQL Server

- Previous
  - 1
    - RESTORE DATABASE Deepak Rangarajan wrote: If the database is being newly created from a backup file proceed as shown below, RESTORE DATABASE dbname FROM DISK ='Path of your backup file' If the databasealready existing and you are going to overwrite it then proceed as shown below, RESTORE DATABASE dbname FROM DISK = 'path of backup file' WITH MOVE 'logical filename' TO 'path.mdf', MOVE 'logical filename' TO 'path.ldf' by default it will be in recovery only unless you explicitly specify it as norecovery hope this helps Thank you, There is more confusion than I can handle. It is a situation when the database is restored to the folder where it does not exist. Secondly, I just installed Vista OS and the backups were all done from my XP partition. I copied all my databases except this one which appears to be screwed up. The mdf file cannot be found on XP although I can view all tables and the database itself in Server Explorer in SSMS in XP. Also for your info it is SQLEXPRESS. I posted this question over there but nobody seems to be able to handle it. OK, now it this: I do not have logical name. When I tried recovery with a similar command I got an error that ... I do not quite remember the format but the content was that I should run RESTORE FILESLISTONLY to get logical names Does it sound right I did this and got a table with some of the ndf's and one mdf file but the mdf is not this database name. It seems to be a name of database that I created months ago but then deleted. Also I tried to RESTORE from SSMS (Sql Express) by pointing to Databases in Server Explorer and rightCLick==>Restore. The darn thing is with this security obsessed Vista I cannot find a way to cancel this persistent error that "Access is not allowed" when I point later to the backup device. I am the administrator everywhere. I gave permission to a bunch of user groups (for the .BAK file, etc.) but it all seems to be in vain. It is just a horror story with this Vista. I guess my question is: how can I get the logical name. You see, I can read the stuff you showed me in MSDN help myself but I need real life examples to implement them. I do not seem to have them. The examples they give do not seem to fit my particular situation. Even if you explain to me how to get the logical name for this DB most likely it will be wasted since the Vista (or SSMS) again will say that "Access is not allowed.." This is a comprehensive run around. I am the only user of this workstation with low security DBs used primarily for crunching floating point numbers and I am facing such a hard time doing simple things. It is preposterous. Help me if anybody can. Thanks. Tag: inflation factor in Analysis Services 2005
  - 2
    - problem with recursive cte query Wonderful, thank you so much!!! Now, if I can just figure out what it's all doing:) Tag: inflation factor in Analysis Services 2005
  - 3
    - Request for feedback - Aliases have been deprecated for some time and will be removed soon Removing entirely from the SQL server may not be an option, will there be any documentation or MS article released to enable the new users to understand the 'new' concept in addition to BOL . Tag: inflation factor in Analysis Services 2005
  - 4
    - Help with cupe partitioning/processing Hello guys I have an issue with one of our cubes which i hoped someone could help me with... The problem is a historical cube which is currently growing quite drastically, and includes daily history from 2004 until today. The cube is just processed full every single day, and this means processing 80+ million rows every day, when actually most of the data is not changed at all. I decided I want to split my cube in data for 2004, 2005, 2006, 2007 and then the current month. Once the current month is over then i would merge it with the year to date partition and create a new partition for the new month. My problem is how to implement the processing in a simple way Right now the processing is done in SSIS by just processing full the db, so I guessed i have to make 2 tasks, one to process full all the dimensions first , and one to process full the cubes afterwards in which i process for this specific cube only the latest partition. But this means at the end of the month I would have to change the package manually, since i need to merge some partitions and then process full only the newest partition again... Is there any simpler way of doing this Is my approach correct in the partitioning way and processing full of only the newest partition, except at the end of the month when i would need to merge and process the ytd partition Tag: inflation factor in Analysis Services 2005
  - 5
    - Problem running SSIS from C# package.errors did not really give me any useful information. Is there anything else I can look at or canm anybody think of any reason why the SSIS would not work from a C# program but works everyplace else I have others that work and cannot find any difference between the two. Tag: inflation factor in Analysis Services 2005
  - 6
    - MDX Sum distinct across specific dimensions I don't quite understand your suggestion. I do have a table where GroupID is the primary key, but I can't figure out how to get it to count values once for each distinct iteration of Group ID. The rollups and sum distincts across specific dimensions works with Oracle analytic functions, but I can't figure out how to get it to work with MDX. Thanks for your response. Tag: inflation factor in Analysis Services 2005
  - 7
    - OleDB Source and Parameters Hi Rafael, Sorry for the delay in my response, I was travelling. Thanks for your answer - this has worked. I now have a script task at the start of my package that defines the global to/from dates - individual data flow tasks within the package use these values. If execution now fails and I need to run the package on monday or tuesday for past dates, thenI can quickly edit the variable. The expression builder is pretty powerful, although I have some thoughts on this approach: Be wary of Data Types - for example, variable data type is a string, haven't found a good way to cast the data type in the expression without causing errors (cast operator documentation not very good) This is pretty cryptic when you think about it - placing a variable into a query required me to build an expression...seems complicated for what I'm tyring to achieve Also, "Evaluate expression" button/function - glad this is there, a must have piece of functionality Thanks for your help!! Tag: inflation factor in Analysis Services 2005
  - 8
    - searching similar records within a table Code Block select cd .* from #calldetail cd inner join #call c on cd . calldetailid = c . calldetailid inner join #request r on c . callid = r . callid inner join #requestdetail rd on r . requestid = rd . requestid where exists ( select 1 from #request r2 inner join #requestdetail rd2 on r2 . requestid = rd2 . requestid where r . cityno = r2 . cityno and rd . customername = rd2 . customername and r . requestid <> r2 . requestid ) and cd . calldetailid = 6532 Tag: inflation factor in Analysis Services 2005
  - 9
    - How to Create Assembly function using dll files in SQL Server 2005??? Hiii yes i have both sql server 2000 and sql server 2005 and .net 2003 and .net 2005 both are installed Actually there is no any type of group by concate function in sql server 2000- 2005 so tht i have made a class file in c# 2.0 and make a dll file of tht class file and now sql server 2005 is supporting CLR Integration so tht i want to use tht function in my SQL Server 2005 instead of group by concate, I have already enabled clr enable in my sql server 2005. but as i think i need to create a assembly function in sql server like CREATE ASSEMBLY abc From "c:\abc.dll" So this statement gives me error so if you have any other option to do this then plz plz help me thanking youuuuuuuuuuuuuuu... Pratik Kansara Tag: inflation factor in Analysis Services 2005
  - 10
    - Database user and Corresponding login dbo is used by sa login to access a database.You find Null for loginName because that user have not an login in server. Test a scenario with M Studio: create a login 'aa' and in a database create user 'bb' that correspond that login then run sp_helpuser before and after you delete login aa. If a login has a database default that login has an user database that correspond for it. Default sa login has master database as default database so, if dbo has a null value in that column from sp_helpuser then dbo has't a login for that database Tag: inflation factor in Analysis Services 2005
  - 11
    - Error while changing Custom Resolver between 2005 Publisher and 2000 Subscriber Thanks a lot Thorsten ! Your post was the solution to our problem !!! Tag: inflation factor in Analysis Services 2005
  - 12
    - Question on Row Count Transformation I believe in the control flow, before the data flow, you will have to "select max(id) from table" and store that in a variable. Then in the data flow, you'll have to use expressions to set the starting number to that of the variable plus one. Also, it's the "Row Number Transformation," not the "Row Count Transformation" just to be clear for those tuning in. SSIS comes with a "Row Count Transformation" built-in. Tag: inflation factor in Analysis Services 2005
  - 13
    - SQL Server SP2 Command Line Upgrade Switch and Express Version Detection Our application installation setup needs to be able to detect: Is SQL Server 2005 Express Installed If false, run the SP2 Installation Is SQL Server 2005 Express or SQL Express SP1 Installed If false, run the SP2 Installation with Update Switch Is SQL Server 2005 (not Express) Installed If true, abort installation with a mesage. Can you direct me to some documentation about testing for these environments or just if someone has some scripts that will run in InstallShield, that would be great. ALSO, can you direct me to information about using the command line update switch for the Express SP2 Installer Thanks. Pat Tag: inflation factor in Analysis Services 2005
  - 14
    - Datetime format for dimension Please help me Thank for replying my requirement I did the same way but the format is not changed.. Also I tried to use that cube in a pivot grid table and tried to change the format there. Still the format is shown as yyyy/mm/dd like that.. Tag: inflation factor in Analysis Services 2005
  - 15
    - Accessing variables using file connection in Execute SQL Task You need to provide more information -it is not clear what you are attempting to accomplish. Also, there is the system variable @@Servername -it will ALWAYS provide the name of the current attached server. Tag: inflation factor in Analysis Services 2005
  - 16
    - Custom Assembly Security I have gone through this article before, based on that (as mentioned in point 2) I have created more or less the same entry in rssrvpolicy.config file. Only difference is that my membership condition is not StrongNameMembershipCondition but UrlMembershipCondition. Is that what is causing the mscorlib not to load In the meantime, I will try with the StrongNameMembershipCondition as well Tag: inflation factor in Analysis Services 2005
- Next
  - 1
    - Error Yes I have default values.That value depends on user selection.If the date difference is less than 15 days.Script will be raised(That I have written using custom code). Tag: inflation factor in Analysis Services 2005
  - 2
    - Advice on dimension-dependant KPI Goals Good idea. Why didn't I think of that. Tag: inflation factor in Analysis Services 2005
  - 3
    - Merge replication error on the subscriber - call sys.sp_MSmakegeneration timing out I have ran sp_lock as don't see any blocking through sp_who , out put of the sp_lock shows that it is holding key locks on tables such as MSmerge_genhistory and MSmerge_contents. Tag: inflation factor in Analysis Services 2005
  - 4
    - Moving ReportServer Databases Nope. Didn't see that part until it was too late. Tag: inflation factor in Analysis Services 2005
  - 5
    - Table Join For 1 Dimension I have a simillar scenario with the only difference being that the 2 tables are in 2 difference data sources. Iam not sure how to make this left join work in this case. The named view UI forces to pick one data source and validates both the table against it. ( in my case table b belongs to a different data source). I even tried using the data souce name as prefix and nothing seems to work even though the documentation clearly mentions that we can create named queries across multiple data source. Any ideas on how to do this Tag: inflation factor in Analysis Services 2005
  - 6
    - Hiding Non Empty Dimension members when using pivot tables I do have a number of calculated measures that evaluate to zero for the dimension members that I expect to be empty. Is there any way that I can supress this Tag: inflation factor in Analysis Services 2005
  - 7
    - some questions about SMK That mean regenerate SMK does not influence the encryption object such as certificate,asymmetric key Tag: inflation factor in Analysis Services 2005
  - 8
    - Automate backup for SQL 2005 IF you are using SQL Express, you may wish to explore this thread. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2312915&SiteID=1 Tag: inflation factor in Analysis Services 2005
  - 9
    - Cannot create a custom task ok, so how would I resolve this I kind of copied an example when it came to the namespace, etc... so I'm not sure I have that right. How would I change the type name Tag: inflation factor in Analysis Services 2005
  - 10
    - multi-value parameter in Master report passing to single param sub-report in a list. Here is one way to accomplish this if your parameter values come from a query: In your main report, add a list to the body bound to the same data set as the multi-value parameter. On the list, add a Filter with the following properties: Expression: The same as used to populate the parameter value. Operator: In Value: Use the parameter value (i.e. =Fields!MyMultiValueParam.Value) Because the parameter is a multi-value parameter, this will evaluate to an array. Inside the list, add your subreport and use Filter/Parameter Value expression as the subreport's parameter value. This example, based on the standard AdventureWorks database that ships with SQLServer 2005 may be helpful. I've left out the code for the subreport, but the only important thing is that it has a parameter called "Category". MainReport: Code Block < xml version = " 1.0 " encoding = " utf-8 " > < Report xmlns = " http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition " xmlns:rd = " http://schemas.microsoft.com/SQLServer/reporting/reportdesigner " > < DataSources > < DataSource Name = " AdventureWorks " > < DataSourceReference > AdventureWorks </ DataSourceReference > < rd:DataSourceID > f73d41ec-1fcc-4920-a330-a241753e2ca5 </ rd:DataSourceID > </ DataSource > </ DataSources > < BottomMargin > 1in </ BottomMargin > < RightMargin > 1in </ RightMargin > < ReportParameters > < ReportParameter Name = " Category " > < DataType > Integer </ DataType > < DefaultValue > < DataSetReference > < DataSetName > DataSet1 </ DataSetName > < ValueField > ProductCategoryID </ ValueField > </ DataSetReference > </ DefaultValue > < AllowBlank > true </ AllowBlank > < Prompt > Category </ Prompt > < ValidValues > < DataSetReference > < DataSetName > DataSet1 </ DataSetName > < ValueField > ProductCategoryID </ ValueField > < LabelField > Name </ LabelField > </ DataSetReference > </ ValidValues > < MultiValue > true </ MultiValue > </ ReportParameter > </ ReportParameters > < rd:DrawGrid > true </ rd:DrawGrid > < InteractiveWidth > 8.5in </ InteractiveWidth > < rd:SnapToGrid > true </ rd:SnapToGrid > < Body > < ReportItems > < List Name = " list1 " > < Left > 0.625in </ Left > < Filters > < Filter > < Operator > In </ Operator > < FilterValues > < FilterValue > =Parameters!Category.Value </ FilterValue > </ FilterValues > < FilterExpression > =Fields!ProductCategoryID.Value </ FilterExpression > </ Filter > </ Filters > < ReportItems > < Subreport Name = " subreport1 " > < Left > 0.25in </ Left > < Parameters > < Parameter Name = " Category " > < Value > =Fields!ProductCategoryID.Value </ Value > </ Parameter > </ Parameters > < Top > 0.375in </ Top > < ReportName > TopProductsInCategory </ ReportName > </ Subreport > </ ReportItems > < DataSetName > DataSet1 </ DataSetName > < Top > 0.5in </ Top > < Width > 3.25in </ Width > </ List > </ ReportItems > < Height > 3.875in </ Height > </ Body > < rd:ReportID > 8ae4521d-b4b6-4bdd-86a2-e4bec1967b4d </ rd:ReportID > < LeftMargin > 1in </ LeftMargin > < DataSets > < DataSet Name = " DataSet1 " > < Query > < rd:UseGenericDesigner > true </ rd:UseGenericDesigner > < CommandText > select ProductCategoryID, Name from Production.ProductCategory </ CommandText > < DataSourceName > AdventureWorks </ DataSourceName > </ Query > < Fields > < Field Name = " ProductCategoryID " > < rd:TypeName > System.Int32 </ rd:TypeName > < DataField > ProductCategoryID </ DataField > </ Field > < Field Name = " Name " > < rd:TypeName > System.String </ rd:TypeName > < DataField > Name </ DataField > </ Field > </ Fields > </ DataSet > </ DataSets > < Width > 6.5in </ Width > < InteractiveHeight > 11in </ InteractiveHeight > < Language > en-US </ Language > < TopMargin > 1in </ TopMargin > </ Report > Tag: inflation factor in Analysis Services 2005
  - 11
    - Shared datasource in different folder... Hi all, Ive tried searching but nothing came up specific to my problem. I currently have all the reports separated into separate folders, such as Finance, HR etc, and the datasources in a datasources folder at the root level. My problem is that when i upload reports into their appropriate folder, the shared datasource information gets deleted, and i need to re-map it everytime. Is there anyway to have the specific reports point to specific shared datasource folders on the report server when i upload them cheers Rob. Tag: inflation factor in Analysis Services 2005
  - 12
    - SQL 2005 EXPRESS & ORACLE 10g Hi all, I am trying to link Oracle 10g (32bit) to SQL 2005 Express. My environment is: -SQL 2005 Express & Oracle 10g run to Windows 2000 - Oracle client is installed to the server I use either "New linked server" from Management studio or I run sp_addlinkedsever & sp_addlinkedsrvlogin to add the new oracle server. The server is succesfully created under "Linked servers" without any error. The point is I do not find the Oracle tables from within Management studio. Do I miss any step I tried both Microsoft & Oracle OLE DB, but i failed To the same server is also installed SQL 2000. From within Enterprise manager I linked Oracle 10g database without any error. Also I see the tables and run select statements. I used both Microsoft & Oracle OLE DB. Can anybody help Tag: inflation factor in Analysis Services 2005
  - 13
    - sql server agent service failure This scenario should be supported. What's your machine name look like Any special chars and symbols (like dash "-") Tag: inflation factor in Analysis Services 2005
  - 14
    - Tell Us Your Express Story and Win $100! It means you are giving your Intellectual property away I never trust these competitions Tag: inflation factor in Analysis Services 2005
  - 15
    - On Delete Triggers Question Thanks for the quick answer So what is the "FOR DELETE" for I assume that the "INSTEAD OF" triggers disable table trigger for the scope Tag: inflation factor in Analysis Services 2005
  - 16
    - How to update a table Identity based on another table Identity? As an FYI sidebar. Identity columns can be reset to go forward from a different starting point. DBCC CHECKIDENT('mytable' RESEED, *starting value*) One must be careful not to create an overlap if you use a prior number or range in the reseed. You can clone from one table to another like so: declare @id int set @id = ident_current('source_tbl') + ident_incr('source_tbl') dbcc checkident ('target_tbl', reseed, @id) Tag: inflation factor in Analysis Services 2005

IsaacBS

Anybody knows how to apply an inflation factor depending on the date to a measure in Analysis Services 2005

The Inflation Factor is (Current Month Rate / X Month Rate)

So lets say for current year the rates are

Jan 121.64

Feb 121.98

March 122.244

April 122.171

For example

If I want to calculate for March I would show a column for January February and March, the column for January would be multiplied by (122.244/121.64) the column for February would be multiplied by (122.244/121.98) and march by one (122.244/122.244)

But in April the factors would be different I would have 4 columns, January February March and April, January amounts would be multiplied by (122.171/121.64) February by (122.171/121.98) March by (122.171/122.244) and April by one (122.171/122.171)

Im using SSAS 2005

Thanks in advance

Isaac

Top

Re: inflation factor in Analysis Services 2005

Bryan C. Smith

I don't think this is what you are after, but maybe it is ( ):

Code Block

with member [Measures].[x] as

([Date].[Calendar].CurrentMember,[Measures].[Reseller Sales Amount])/([Date].[Calendar].CurrentMember.PrevMember,[Measures].[Reseller Sales Amount])

,format_string="0.00%"

select

{[Reseller Sales Amount],[x]} on 0,

[Date].[Calendar].[Month].Members on 1

from [Adventure Works]

;

Top