Who is online?  0 guests and 1 members
Home  »  search results

Search Results: Trend

32 results found
  • SSAS KPI Trend
    KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is trending in right direction based on previous levels. If you want to show a measure has increased or decreased since last month, this can be accomplis
    Author: MikeDavis MikeDavis     Date: 4/22/2011     Section: Blog
    tags : Cube, MDX, SSAS, Trend, KPI
  • MDX equivalent to T-SQL UNION
    Hi. The following MDX query returns what I want for a single KPI. WITH MEMBER [KPI Name] AS "Some KPI" MEMBER [KPI Value] As KPIValue("Some KPI") MEMBER [KPI Status] AS KPIStatus("Some KPI") MEMBER [KPI Trend] As KPITrend("Some KPI") SELECT { [KPI Name],
    Author: JustinJohnson JustinJohnson     Date: 1/20/2011     Section: Forum
    tags : KPIs, MDX, union
  • Trend line for Line chart in SSRS 2005
    This article will help to draw the Trend Line for Line chart in SSRS 2005 .this was done through by calculating the data points for the specific data .the mathematical formula for find the trend line was Y=Mx+C.i was searched more links to solve this prob
    Author: karthi.kamal karthi.kamal     Date: 5/24/2012     Section: Article
  • SSIS + CDC = SCD -- A PASS webinar on 20th December by Patrick LeBlanc
    I got interested in the title of this webinar and hence thought that all of you might be interested in this webinar event as well. Below are the details Date / Time Date: 12/20/2010 Start Time: 12:00:00 PM End Time: 1:00:00 PM Timezone: (GMT-05:00) Easter
    Author: indupriya indupriya     Date: 12/16/2010     Section: Blog
  • Setting up KPI goals
    I wrote a couple of blogs on KPI's that I think answer your question. http://www.bidn.com/blogs/MikeDavis/ssis/1760/ssas-dynamic-kpi-from-a-table http://www.bidn.com/blogs/MikeDavis/ssis/1761/ssas-kpi-trend
    Author: MikeDavis MikeDavis     Date: 7/12/2011     Section: Forum
    tags : kpis, ssas
  • SSIS vs. Informatica
    Well ... Informatica was pioneer in ETL market … they came very first in the market they dominated many fortune 500 hundred companies... But since then MS Seriously invested in BI Segment and current trend is MS BI is the fastest growing trend due to many
    Author: NayanPatel NayanPatel     Date: 7/14/2011     Section: Forum
  • Trend LIne for Line Chart in SSRS 2005
    Hi All myself is karthi and i m new to SSRS.i need the Trend line for the follwing data in Line chart they are the follwing data .The following are the graph are my output and i need the trend line for these Key_gap value.This is the link I was refereed h
    Author: karthikeyan karthikeyan     Date: 5/4/2012     Section: Forum
  • The Whaty-What of Data Mining Algorithms in SSAS
    SQL Server Analysis Services features nine different data mining algorithms that looks for specific types of patterns in trends in order to make predictions about your data. This is a potentially very powerful tool and since I've been learning more about
    Author: DustinRyan DustinRyan     Date: 4/2/2013     Section: Blog
  • Job Step Settings for Executing Packages Containing Excel Componenets on a 64-bit Machine
    Many of the SSIS packages you'll see on the job might use Excel workbooks as a source or destination for your data. Another trend that's becoming increasingly common is the use of 64-bit machines for your ETL processing. However, with the combination of t
    Author: kylewalker kylewalker     Date: 8/16/2011     Section: Blog
  • New features of SSRS 2008 R2 - Part 2 Report Part Gallery
    Report Part Gallery is a promising addition to the SSRS product in SQL Server 2008 R2 (currently using Nov CTP release). Imagine this: Jerry, a member of your team of developers, creates a series of cool data regions or charts that show key company metric
    Author: bretupdegraff bretupdegraff     Date: 12/4/2009     Section: Blog
  • Creating Sparklines in PowerPivot
    Sparklines are new to Microsoft Excel 2010 and Reporting Services 2008 R2. In this post I will outline the steps required to create sparklines in an existing PowerPivot workbook. Sparklines provide you with the ability to create a trending graph inline wi
    Author: PatrickLeBlanc PatrickLeBlanc     Date: 5/9/2010     Section: Blog
  • KPIs in BI Documenter
    Key Performance Indicators (KPI), they are a collection of calculations associated with a measure group in a cube. Typically these calculations are a combination of Multidimensional Expressions (MDX) or calculated members. A simple KPI object is composed
    Author: TMMichau TMMichau     Date: 12/27/2012     Section: Blog
  • Free Webinar : Multidimensional Reporting: MDX Essentials for Report Design
    PASS DW/BI VC Presents: Multidimensional Reporting: MDX Essentials for Report Design Date / Time Date: 2/23/2011 Start Time: 12:00:00 PM End Time: 1:00:00 PM Timezone: (GMT-05:00) Eastern Time (US & Canada) Short Description Learn the fundementals of
    Author: meganathank meganathank     Date: 2/23/2011     Section: Blog
  • please need help in tracking a package for a table
    How many packages do you have? If you want some really cool, detailed, monitoring of your SSIS enviornment I recommend you check out BIxPress *. Just apply the auditing framework to the packages (don't worry, it's easy to add/remove it). Once you do that
    Author: sqlchicken sqlchicken     Date: 4/25/2012     Section: Forum
    tags : ssis auditing
  • Logging in SSIS 2008
    I would use a script task to custom log to a text file. Too much work, I would go with a table. This gives you the ability to query the table and find trends in the package times.
    Author: MikeDavis MikeDavis     Date: 2/24/2011     Section: Forum
    tags : logging, ssis
  • BIxPress - Capabilities?
    Hi Umayal! By hierarchical packages, do you mean parent/child packages? Yes, BIxPress monitors them and their individual failures. To see the package at a high level, in the Report - Execution ControlFlow Diagram, click on the master package to see all of
    Author: sqlchicken sqlchicken     Date: 8/6/2012     Section: Forum
    tags : auditing, BIXpress
  • Report Builder 2 - failed to load
    I've got Report Builder 2 installed in Integrated Mode with Sharepoint, however when I try to open a report builder report from a document library with "Edit in Report Builder", I get the message: Application Validation did not succeed: The error message
    Author: MarkGStacey MarkGStacey     Date: 1/19/2010     Section: Forum
  • Moving from Oracle-Cognos BI to MS technologies. Is it downgrading yourself in BI technologies?
    Thanks Will and Mark for reply. I experienced same thing that Mark is mentioning. Core users prefer to work on proven BI technologies and mostly that in non MS. I was discussing recently with a senior guy in one of the KPO company. They are well establish
    Author: ashishnaik1 ashishnaik1     Date: 1/21/2010     Section: Forum
  • Im new on SSIS, Can anyone helpme with a simple project?
    If you're just looking for a homegrown monitoring solution then I recommend you check out some of the stuff available over at Codeplex such as this: http://sqlcms.codeplex.com/ If you're looking to learn how to use and apply SSIS in your environment then
    Author: sqlchicken sqlchicken     Date: 7/20/2011     Section: Forum
  • Find Current Snapshot and Previous Snapshot Value using MDX Query
    HI, Could you please tell me How the MDX query should be to find Current Snapshot value Previous Snapshot Value. I have a fact table which will be populated with all the data pertianing to all the months for that project. Every month a snapshot will be ge
    Author: marksmiley marksmiley     Date: 8/14/2011     Section: Forum
  • Previous Month Data and Current Month Data
    Hi, My requirement is : When Dashboard page loads by default i need to display Current Snapshot Value and for each column in KPI has a trend to compare the current snapshot value with Previous snapshot data. In my scenario, my Fact table will have n numbe
    Author: marksmiley marksmiley     Date: 8/16/2011     Section: Forum
  • Designing DataWareHouse OLAP, Minings for Health Care
    Hi All Can I have Any Design Help on Datawarehouse Design for health care . I have OLTP Database Records for Pataients/ Admissions/Proceduers given along with the results. What Useful information i can construct to help the Hospital. How can i design Mini
    Author: vineet_bidn_dubey vineet_bidn_dubey     Date: 4/5/2011     Section: Forum
  • Combining Aggregate function and STRTOSET function in Dynamic query
    STRTOSET(@DiallerCampaignDetailsCallDirection, CONSTRAINED), [Dialler Campaign Details].[Call Direction].currentmember ), ="WITH " & "MEMBER [Measures].[Selected Measure] AS [Measures].[" & Parameters!MeasureName.Value & "] " & "MEMBER [Me
    Author: CarlThompson CarlThompson     Date: 8/13/2012     Section: Forum
  • New Years Resolutions
    I hope everyone had a great start to the new year. Last year, I learned a lot and hope to continue learning all throughout 2012. I normally don?t bother with New Year?s Resolutions, but this time around I will make an exception. This year, I plan to hit S
    Author: ShawnHarrison ShawnHarrison     Date: 1/3/2012     Section: Blog
  • SSAS Dynamic KPI from a table
    KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is above or below a goal. Managing the goal numbers can be a headache because they made need to be updated often. By placing the goal numbers on a table
    Author: MikeDavis MikeDavis     Date: 4/21/2011     Section: Blog
    tags : Dynamic, Goal, MDX, SSAS, Table, Trend, KPI