microsoft.public.sqlserver.olap
- Inline calculated members., Jimmy
- pivot tables - sharepoint, peter.feakins@xxxxxxxxxx
- Copy database from development PC to deplyment server,
msnews.microsoft.com
- Re: Copy database from development PC to deplyment server, Dave Wickert [MSFT]
- analysis services processing task not visible in sql server Packag,
joia
- Re: analysis services processing task not visible in sql server Packag, Dave Wickert [MSFT]
- Archive a cluster (remote server), verbani
- CellSetGrid error due to doctype, brandon . beacher
- Cannot connect to cube file <IP Address>, file may be in use, karenmiddleol
- OWC versions 9-11 comparison, papacito
- Java-based web access to Analysis Services cubes, vachesacree
- Please help!! MDX for default member,
Angie via SQLMonster.com
- Re: Please help!! MDX for default member, Angie via SQLMonster.com
- Date Help needed!!!, Carrie Taylor
- MSSQLServerOLAPService -- Hangs up in "Starting" status, madan_eee@xxxxxxxxxxx
- Calculated Member-Sales over $x, papacito
- Calculation with previous Month End Figure,
stathi anagnostatos via SQLMonster.com
- Re: Calculation with previous Month End Figure, OLAPMonkey
- MS OLAP and IIS 5.0, mansoorak77
- MTD product of a calculated member,
lawk
- Re: MTD product of a calculated member, OLAPMonkey
- Closing period, bttfrc
- Multiple selections and Drillthrough compatibility,
WeshaTheLeopard
- Re: Multiple selections and Drillthrough compatibility, Michael Vardinghus
- MDX Exp Syntax Help, Prasad
- Migrating from Essbase To Microsoft Analysis Services, don
- Please help with http connectivity using msolap.asp, David
- Error in HTTP connection to OLAP cubes, Angie via SQLMonster.com
- Need to filter MDX by Current Date..., Debzidoodle
- MDx:Choosing a set syntax.,
Antony Altobelli via SQLMonster.com
- <Possible follow-ups>
- MDx:Choosing a set syntax., Antony Altobelli via SQLMonster.com
- MDx:Choosing a set syntax., Antony Altobelli via SQLMonster.com
- MDx:Choosing a set syntax.,
Antony Altobelli via SQLMonster.com
- Message not available
- Re: MDx:Choosing a set syntax., Anthony A. via SQLMonster.com
- Message not available
- Set "All caption" in Dimension with DSO,
Ernesto LEITE via SQLMonster.com
- Re: Set "All caption" in Dimension with DSO,
Gautham Kamath via SQLMonster.com
- Re: Set "All caption" in Dimension with DSO, Dave Wickert [MSFT]
- Re: Set "All caption" in Dimension with DSO,
Gautham Kamath via SQLMonster.com
- How to aliase columns in MDX like in T-SQL,
karenmiddleol
- Re: How to aliase columns in MDX like in T-SQL, OLAPMonkey
- Data Source properties,
Javier Catala
- Re: Data Source properties,
Dave Wickert [MSFT]
- Re: Data Source properties,
Javier Catala
- Re: Data Source properties, Dave Wickert [MSFT]
- Re: Data Source properties,
Javier Catala
- Re: Data Source properties,
Dave Wickert [MSFT]
- Project REAL webcast,
Dave Wickert [MSFT]
- Re: Project REAL webcast,
Michael Vardinghus
- Re: Project REAL webcast,
Dave Wickert [MSFT]
- Re: Project REAL webcast, Michael Vardinghus
- Re: Project REAL webcast, Dave Wickert [MSFT]
- Re: Project REAL webcast, Michael Vardinghus
- Re: Project REAL webcast,
Dave Wickert [MSFT]
- Re: Project REAL webcast,
Michael Vardinghus
- disregard above post reposted with MDX, papacito
- mdx TopSum - basic question, papacito
- TopSum syntax question-basic, papacito
- About the MDX Query, Sarah
- Usage based optimization wizard and calculated members,
Michael Barrett Jensen
- Re: Usage based optimization wizard and calculated members,
Dave Wickert [MSFT]
- Re: Usage based optimization wizard and calculated members, Michael Barrett Jensen
- Re: Usage based optimization wizard and calculated members,
Dave Wickert [MSFT]
- Client update for SP4 necessary?,
Matthias
- Re: Client update for SP4 necessary?, Dave Wickert [MSFT]
- WITH Member & dimension security,
saulat
- Re: WITH Member & dimension security, OLAPMonkey
- Drillthrough and roles,
arcticpuppy
- Re: Drillthrough and roles, Dave Wickert [MSFT]
- SP4 Update Cube regression bug ?, Michel CARADEC
- Event Viewer error, Fredrik
- URGENT - Cannot connect to repository after installing SP4, Andrea Temporin
- Re: DrillThrough in Excel 2000, John Jayaseelan
- MDX - Member Key,
Ale Dori
- Re: MDX - Member Key, Vladimir Chtepa
- Member names not refreshing in Excel, Gary B
- Parent-Child Dimension aggregation, Kevin R .
- Calculated Measure - Percent, Tim Chapla
- Waiting for Features in IA64 MSSQL2005-Beta 3 or final release & w,
Bob H.
- Re: Waiting for Features in IA64 MSSQL2005-Beta 3 or final release & w, Dave Wickert [MSFT]
- Urgent: Strange connection error after setting Drillthrough timeou, Stan Kondrat
- Convert Function, Pete Straman Straman via SQLMonster.com
- ROW or COLUMN or FILTER DIMENSION,
Prasad
- Re: ROW or COLUMN or FILTER DIMENSION, Vladimir Chtepa
- Urgen! AS as linked server produces errors after SP4 was installed., Vladimir Chtepa
- Changing data sources with Analysis Services,
rachel.jones@xxxxxxxxxxxx
- Re: Changing data sources with Analysis Services,
OLAPMonkey
- Re: Changing data sources with Analysis Services,
Rachel Jones
- Re: Changing data sources with Analysis Services, rachel.jones@xxxxxxxxxxxx
- Re: Changing data sources with Analysis Services, Dave Wickert [MSFT]
- Re: Changing data sources with Analysis Services, Rachel Jones
- Re: Changing data sources with Analysis Services, rachel.jones@xxxxxxxxxxxx
- Re: Changing data sources with Analysis Services, Dave Wickert [MSFT]
- Re: Changing data sources with Analysis Services, Rachel
- Re: Changing data sources with Analysis Services, Dave Wickert [MSFT]
- Re: Changing data sources with Analysis Services,
Rachel Jones
- Re: Changing data sources with Analysis Services,
OLAPMonkey
- Excel as a XML/A Client,
karenmiddleol
- Re: Excel as a XML/A Client, Dave Wickert [MSFT]
- All member formula,
Resho
- Re: All member formula, Dave Wickert [MSFT]
- Drill Thru from Excel,
Suresh Kumar
- Re: Drill Thru from Excel, Alejandro Leguizamo \(MVP\)
- Re: Drill Thru from Excel, Vini
- writing in cubes - advice, Radu Colceriu
- RE: DTS which used to process a cube now fails??, Misha_SQL
- create a mutually exclusive dimension,
jason.saldo@xxxxxxxxx
- Re: create a mutually exclusive dimension,
jason.saldo@xxxxxxxxx
- Re: create a mutually exclusive dimension, jason.saldo@xxxxxxxxx
- Re: create a mutually exclusive dimension,
jason.saldo@xxxxxxxxx
- Trend Analysis???,
Todd Bright
- Re: Trend Analysis???,
Vini
- Re: Trend Analysis???, Todd Bright
- Re: Trend Analysis???,
Vini
- MM:SS, hpanneflek
- Urgent! please help - Disabling dimension levels,
Angie via SQLMonster.com
- Re: Urgent! please help - Disabling dimension levels, Michael Vardinghus
- Year Ago Calculation on PERIOD Hierarchy, Sampa2870
- FoodMart 2000 TopCount question..., crw
- MDX TopCount problem..., CRW
- Best practices to partition a cube by month,
Jesse O
- RE: Best practices to partition a cube by month, Matt Kennedy
- table structure for olap,
dk
- Re: table structure for olap,
Eleazar
- Re: table structure for olap, Michael Vardinghus
- Re: table structure for olap,
Eleazar
- security by IP range for seperate report applications on single RS, Paul
- process cubes via DTS on web server,
Joel Leong
- Re: process cubes via DTS on web server, Dave Wickert [MSFT]
- Aggregation Types (Additive or NOT) and Distinct count., Catalin Bobarnac
- Calculated members security,
akber via SQLMonster.com
- Re: Calculated members security, Thomas Ivarsson
- mdx for distinct count not working!, Bharati via SQLMonster.com
- Performance counters stoped working after sp4, Ramunas Balukonis
- Automation Server Can't Create Object on BI Portal 2003, Hendra Eka Putra via SQLMonster.com
- Cube action on PivotView, Bharati via SQLMonster.com
- calculated member, peter.feakins@xxxxxxxxxx
- drill thru for the specific cell, Ragu
- Aggregations for TopCount,
Peter
- RE: Aggregations for TopCount, Chris Webb
- cannot find dimension member in a name-binding function,
Jonathan Levine
- RE: cannot find dimension member in a name-binding function,
Peter Yang [MSFT]
- RE: cannot find dimension member in a name-binding function,
Jonathan Levine
- RE: cannot find dimension member in a name-binding function, Peter Yang [MSFT]
- RE: cannot find dimension member in a name-binding function,
Jonathan Levine
- RE: cannot find dimension member in a name-binding function,
Peter Yang [MSFT]
- Date-based calculated sets, Jeff Davis
- Filtering vs. Partitioning,
Jesse O
- Re: Filtering vs. Partitioning,
Jéjé
- Re: Filtering vs. Partitioning, Jesse O
- Re: Filtering vs. Partitioning,
Jéjé
- Excel Row limitations,
papacito
- Re: Excel Row limitations, Jéjé
- Re: Excel Row limitations, Michael Vardinghus
- Please help - Percentage query,
Brian via SQLMonster.com
- Re: Please help - Percentage query, Brian via SQLMonster.com
- Stddev Aggregation Type, Tim Chapla
- MSAS activity loggin,
Jeroen
- Re: MSAS activity loggin, Dave Wickert [MSFT]
- Possible to process dimensions in parallel in DSO?,
Jesse O
- Re: Possible to process dimensions in parallel in DSO?, Dave Wickert [MSFT]
- Excel 2003 with Analysis Services 2005 (Beta2), Andrew
- Unable to connect remotely, Peter Feakins
- Bypassing a level in the Dimension, Akber
- Urgent !! Virtual cube query,
angie via SQLMonster.com
- Re: Urgent !! Virtual cube query,
angie via SQLMonster.com
- Re: Urgent !! Virtual cube query,
Brian via SQLMonster.com
- Re: Urgent !! Virtual cube query, Jonathan Stern
- Re: Urgent !! Virtual cube query,
Brian via SQLMonster.com
- RE: Urgent !! Virtual cube query, Jonathan Stern
- Re: Urgent !! Virtual cube query,
angie via SQLMonster.com
- IIF AND,
jerstep
- Re: IIF AND, jerstep
- repository problem (DSO),
Steven Jonckheere
- Re: repository problem (DSO), Dave Wickert [MSFT]
- Misleading dimension 2, Oliver
- Urgent! - Copying Missing values,
angie via SQLMonster.com
- Re: Urgent! - Copying Missing values, Dave Wickert [MSFT]
- MDX - Calculated Members, jerstep
- Dropping a local cube, karenmiddleol
- NULL Values in fact table,
Tim Chapla
- Re: NULL Values in fact table, Jesse O
- Re: Seeking way to automate deploying cubes to non-techie customer,
MartinDS
- Re: Seeking way to automate deploying cubes to non-techie customer, Dave Wickert [MSFT]
- Distributed cubes, MartinDS
- Analysis Server DTS not available, TroyS
- HELP!! Balance Calc, rama via SQLMonster.com
- ExcludeEmpty, Rodrigo Faustino
- Aggregate Function in Cube Editor, Tim Chapla
- A challenge design question, DNG
- Have you ever used 2 Data SSources in a cube?,
Prasad
- Re: Have you ever used 2 Data SSources in a cube?, Dave Wickert [MSFT]
- Lookup Table to Dimension,
Tim Chapla
- RE: Lookup Table to Dimension,
SQL McOLAP
- Re: Lookup Table to Dimension, Tim Chapla
- RE: Lookup Table to Dimension,
SQL McOLAP
- Pushing the boundaries with Dynamic Dimension Security, Koan B
- Retrieve dimensions when a dimension is restricted for a particular role, Usmani
- Re: Distributed Cubes at Several Servers, MartinDS
- avg ytd,
Tony
- RE: avg ytd,
SQL McOLAP
- Re: avg ytd, Tony
- RE: avg ytd,
SQL McOLAP
- Autoexist,
Resho
- Re: Autoexist,
Andrej Hudoklin
- Re: Autoexist, Resho
- Re: Autoexist,
Andrej Hudoklin
- Topcount for each member of a dimension, nav . daheley
- Microsoft OLE DB Provider for Analysis Services 9.0,
Rouven Hertenstein
- Re: Microsoft OLE DB Provider for Analysis Services 9.0, Dave Wickert [MSFT]
- multiple hierarchies of a dim in the same cube?, rama via SQLMonster.com
- How to do a OR in the where clause,
karenmiddleol
- Re: How to do a OR in the where clause,
Vini
- Re: How to do a OR in the where clause,
karenmiddleol
- Re: How to do a OR in the where clause, MartinDS
- Re: How to do a OR in the where clause,
karenmiddleol
- Re: How to do a OR in the where clause,
Vini
- Building a Dimension, Granville
- Scenarios for deploying local cubes,
karenmiddleol
- Re: Scenarios for deploying local cubes,
Tim Peterson
- Re: Scenarios for deploying local cubes,
karenmiddleol
- Re: Scenarios for deploying local cubes, Tim Peterson
- Re: Scenarios for deploying local cubes,
karenmiddleol
- Re: Scenarios for deploying local cubes,
Michael Vardinghus
- Re: Scenarios for deploying local cubes,
karenmiddleol
- Re: Scenarios for deploying local cubes, Michael Vardinghus
- Re: Scenarios for deploying local cubes, Michael Vardinghus
- Re: Scenarios for deploying local cubes,
karenmiddleol
- Re: Scenarios for deploying local cubes,
Tim Peterson
- how to determine "analysis services" version using c#,
cct
- Re: how to determine "analysis services" version using c#, Dave Wickert [MSFT]
- Value Expression in Cube Editor, M V via SQLMonster.com
- Cube corrupted?,
nick
- RE: Cube corrupted?, nick
- RE: Cube corrupted?, SQL McOLAP
- MDX Expression Help - Identify Row, Column, Filter Dimensions., Prasad
- Sorting OLAP data Cubes in Excel 2003,
Andrew Alfaro via SQLMonster.com
- Re: Sorting OLAP data Cubes in Excel 2003, Andrew Alfaro via SQLMonster.com
- Calculated measures in virtual cube visible form Excel Pivot Table?,
Patrick Flaherty
- RE: Calculated measures in virtual cube visible form Excel Pivot Table,
SQL McOLAP
- Re: RE: Calculated measures in virtual cube visible form Excel Pivot Table, Patrick Flaherty
- Re: RE: Calculated measures in virtual cube visible form Excel Pivot Table, Patrick Flaherty
- Re: RE: Calculated measures in virtual cube visible form Excel Pivot Table, Patrick Flaherty
- Re: Calculated measures in virtual cube visible form Excel Pivot Table?,
Deepak Puri
- Re: Calculated measures in virtual cube visible form Excel Pivot Table?, Patrick Flaherty
- Re: Calculated measures in virtual cube visible form Excel Pivot T,
SQL McOLAP
- Re: Calculated measures in virtual cube visible form Excel Pivot T, Deepak Puri
- Re: Calculated measures in virtual cube visible form Excel Pivot T, Patrick Flaherty
- Re: Calculated measures in virtual cube visible form Excel Pivot T, Deepak Puri
- Re: Calculated measures in virtual cube visible form Excel Pivot T, Patrick Flaherty
- Re: Calculated measures in virtual cube visible form Excel Pivot T, Deepak Puri
- Re: Calculated measures in virtual cube visible form Excel Pivot T, SQL McOLAP
- RE: Calculated measures in virtual cube visible form Excel Pivot Table,
SQL McOLAP
- "SELECT *" in MDX,
Alex
- RE: "SELECT *" in MDX,
SQL McOLAP
- Re: "SELECT *" in MDX,
MC
- Re: "SELECT *" in MDX, Alex
- Re: "SELECT *" in MDX, MC
- Re: "SELECT *" in MDX,
MC
- RE: "SELECT *" in MDX,
SQL McOLAP
- Connecting using HTTP - VPN, lalberti
- MDX Query,
AC
- RE: MDX Query,
SQL McOLAP
- Re: MDX Query,
AC
- Re: MDX Query, SQL McOLAP
- Re: MDX Query, Andy C
- Re: MDX Query,
AC
- RE: MDX Query,
SQL McOLAP
- BI tool question,
steffi
- Re: BI tool question, JT
- Re: BI tool question,
Deepak Puri
- Re: BI tool question, steffi
- Configure Cube to Ignore Time Portion of DateTime Field, greg_wilkerson
- Authentication on AS,
John Shiangoli via SQLMonster.com
- Re: Authentication on AS, Dave Wickert [MSFT]
- lastPeriods / prev member,
Paul
- Re: lastPeriods / prev member, Deepak Puri
- week dimension error, Sates
- Help : Execute Create cube statement with DSO library?,
Ernesto LEITE via SQLMonster.com
- Re: Help : Execute Create cube statement with DSO library?, Tim Peterson
- Re: Help : Execute Create cube statement with DSO library?,
Tim Peterson
- Re: Help : Execute Create cube statement with DSO library?,
karenmiddleol
- Re: Help : Execute Create cube statement with DSO library?, Tim Peterson
- Re: Help : Execute Create cube statement with DSO library?, Ernesto LEITE via SQLMonster.com
- Re: Help : Execute Create cube statement with DSO library?,
karenmiddleol
- CUBO LOCKED,
Pablo
- Re: CUBO LOCKED, Wayne Snyder
- Re: CUBO LOCKED, Vini
- MDX Multiple Measures,
jerstep
- Re: MDX Multiple Measures, Wayne Snyder
- Mdx Member name enumeration, Andrew Wiles
- SP4 broken my cubes. Cannot save any more.,
crispin . proctor
- Re: SP4 broken my cubes. Cannot save any more., crispin . proctor
- DTS in cube action,
rama via SQLMonster.com
- Re: DTS in cube action, Wayne Snyder
- status as of a given date, rama via SQLMonster.com
- Comparing sales figures,
angie via SQLMonster.com
- Re: Comparing sales figures, Wayne Snyder
- Cumulative sales for a date period, tarana halsall via SQLMonster.com
- Infinite recursion.,
Patrick Flaherty
- Re: Infinite recursion.,
Deepak Puri
- Re: Infinite recursion.,
Patrick Flaherty
- Re: Infinite recursion., Deepak Puri
- Re: Infinite recursion., Patrick Flaherty
- Re: Infinite recursion., Patrick Flaherty
- Re: Infinite recursion.,
Patrick Flaherty
- Re: Infinite recursion.,
Deepak Puri
- Conditional Sum,
txksa
- RE: Conditional Sum, txksa
- RE: MDX with OPENQUERY returning bad results, Steve Hughes
- Security / Role Problem, JIsenstadt
- BI Portal XP with Office 2000 clients. Is it possible?, shpplus
- Drillthrough timeout in Analysis Services 2000?,
Stan Kondrat
- Re: Drillthrough timeout in Analysis Services 2000?,
Deepak Puri
- Re: Drillthrough timeout in Analysis Services 2000?, Stan Kondrat
- Re: Drillthrough timeout in Analysis Services 2000?,
Deepak Puri
- MDX Question,
Rodrigo
- RE: MDX Question,
SQL McOLAP
- RE: MDX Question,
Rodrigo
- RE: MDX Question, SQL McOLAP
- RE: MDX Question,
Rodrigo
- <Possible follow-ups>
- MDX question,
Jesse O
- Re: MDX question, AC
- MDX question,
Jesse O
- RE: MDX question, SQL McOLAP
- RE: MDX Question,
SQL McOLAP
- RE: How to export a cube?, SQL McOLAP
- Unable to connect over VPN - [Possible data corruption], lalberti
- URGENT : Create Dynamic Cube in ANALYSIS Service,
Ernesto LEITE via SQLMonster.com
- RE: URGENT : Create Dynamic Cube in ANALYSIS Service,
David Talbot
- RE: URGENT : Create Dynamic Cube in ANALYSIS Service, Ernesto LEITE via SQLMonster.com
- RE: URGENT : Create Dynamic Cube in ANALYSIS Service,
David Talbot
- Standard deviation calculation,
tarana halsall via SQLMonster.com
- RE: Standard deviation calculation, SQL McOLAP
- Virtual cube,
Ramunas Balukonis
- RE: Virtual cube,
Monte
- Re: Virtual cube, Ramunas Balukonis
- RE: Virtual cube,
Monte
- Incremental Build Errors, Tony
- Filtering a set upon a group of properties, Andrea Temporin
- Scripting the OLAP database,
Ramunas Balukonis
- Re: Scripting the OLAP database, Dave Wickert [MSFT]
- Project reporting, Michael Vardinghus
- BI Accelerator issue with Sample Apps, Alex Thomas
- How to exclude dimension members in a dimension in Pivot report,
karenmiddleol
- Re: How to exclude dimension members in a dimension in Pivot report, Michael Vardinghus
- RE: How to exclude dimension members in a dimension in Pivot report,
SQL McOLAP
- Re: How to exclude dimension members in a dimension in Pivot report,
karenmiddleol
- Re: How to exclude dimension members in a dimension in Pivot repor, SQL McOLAP
- Re: How to exclude dimension members in a dimension in Pivot report, Michael Vardinghus
- Re: How to exclude dimension members in a dimension in Pivot repor, SQL McOLAP
- Re: How to exclude dimension members in a dimension in Pivot repor, karenmiddleol
- Re: How to exclude dimension members in a dimension in Pivot repor, SQL McOLAP
- Re: How to exclude dimension members in a dimension in Pivot repor, karenmiddleol
- Re: How to exclude dimension members in a dimension in Pivot repor, Michael Vardinghus
- Re: How to exclude dimension members in a dimension in Pivot repor, SQL McOLAP
- Re: How to exclude dimension members in a dimension in Pivot repor, karenmiddleol
- Re: How to exclude dimension members in a dimension in Pivot repor, Michael Vardinghus
- Re: How to exclude dimension members in a dimension in Pivot report,
karenmiddleol
- Connection String Problem, Kevin Schulhof
- MDX please help,
karenmiddleol
- Re: MDX please help,
Deepak Puri
- Re: MDX please help, karenmiddleol
- Re: MDX please help,
Deepak Puri
- three hundred dimentions?,
DNG
- RE: three hundred dimentions?, SQL McOLAP
- RE: three hundred dimentions?, SQL McOLAP
- Office Web Components,
Steven Faith
- Re: Office Web Components,
Dave Wickert [MSFT]
- Re: Office Web Components,
Steve
- Re: Office Web Components, Dave Wickert [MSFT]
- Re: Office Web Components,
Steve
- Re: Office Web Components,
Dave Wickert [MSFT]
- forecasting cube, christy
- Multiple hierarchies in the same cube?,
tarana halsall via SQLMonster.com
- RE: Multiple hierarchies in the same cube?, SQL McOLAP
- Dimension permission based on users, tarana halsall via SQLMonster.com
- Lesson 4.sln in 2005 CTP AS tutorial, bhorwatt
- Graphical extension to RS?,
Tony A. via SQLMonster.com
- Re: Graphical extension to RS?, mdxwhip
- Perfomance problem witn ADOMD using from .NET C# application,
Dmitry Penzar via SQLMonster.com
- Re: Perfomance problem witn ADOMD using from .NET C# application,
Dave Wickert [MSFT]
- Re: Perfomance problem witn ADOMD using from .NET C# application, Dmitry Penzar via SQLMonster.com
- Re: Perfomance problem witn ADOMD using from .NET C# application,
Dave Wickert [MSFT]
- More efficient 52-weeks-to-date calc member?,
Matt Kennedy
- RE: More efficient 52-weeks-to-date calc member?,
Chris Webb
- RE: More efficient 52-weeks-to-date calc member?, Matt Kennedy
- RE: More efficient 52-weeks-to-date calc member?,
Chris Webb
- Processing Cube Error on Analysis Services, S. Elliot
- Performance issues when processing a dimension, Jesse O
- Replacing facts table,
Patrick Flaherty
- Re: Replacing facts table, Patrick Flaherty
- RE: Replacing facts table, SQL McOLAP
- Empty measure, Marin
- Dimension with multiple drill down paths, stu
- Automatic grouping on last level greyed out, Jesse O
- calculated member Excel!Correl syntax,
Justin
- <Possible follow-ups>
- calculated member Excel!Correl syntax, Justin
- adding a field to Project Server cube, darren
- Names of months in national language,
Lada Dvorak
- Re: Names of months in national language,
Ramunas Balukonis
- Re: Names of months in national language, Lada Dvorak
- Re: Names of months in national language,
Ramunas Balukonis
- MDX Calculated Member?, nick
- Rights for connect to the cube, Enric
- Re: CREATE CUBE Expert wanted,
George Kousis
- Re: CREATE CUBE Expert wanted, Tim Peterson
- Using Cognos cubes in Scorecard Accelerator, Ticia
- RE: Matlab to MS SQL OLAP database connection?, SQL McOLAP
- Database Design Question,
Tim Chapla
- Re: Database Design Question, Tim Chapla
- Custom member ordering, Malvira
- More info on building cubes from text / data files,
Prasad
- Re: More info on building cubes from text / data files,
Jesse O
- Re: More info on building cubes from text / data files,
Prasad
- Re: More info on building cubes from text / data files, Dave Wickert [MSFT]
- Re: More info on building cubes from text / data files, Prasad
- Re: More info on building cubes from text / data files, Dave Wickert [MSFT]
- Re: More info on building cubes from text / data files,
Prasad
- Re: More info on building cubes from text / data files,
Jesse O
- cube not visible from ms query, joia
- Drillthrough not always working with OWC, AC Dybdahl
- CREATE GLOBAL CUBE,
verbani
- Re: CREATE GLOBAL CUBE, Tim Peterson
- Creation of Fact Table and populating with rows, Bobbyx2405
- MDX Training, mdxwhip
- crossjoin reordering/filtering my set & 2 other questions, mdxwhip
- How to use Analysis Services, ross_co
- Unable to Process Cube on 64bit Server with DTS package,
lancemc5
- Re: Unable to Process Cube on 64bit Server with DTS package,
Jesse O
- Re: Unable to Process Cube on 64bit Server with DTS package,
lancemc5
- Re: Unable to Process Cube on 64bit Server with DTS package, Dave Wickert [MSFT]
- Re: Unable to Process Cube on 64bit Server with DTS package, lancemc5
- Re: Unable to Process Cube on 64bit Server with DTS package, Dave Wickert [MSFT]
- Re: Unable to Process Cube on 64bit Server with DTS package, lancemc5
- Re: Unable to Process Cube on 64bit Server with DTS package, Dave Wickert [MSFT]
- Re: Unable to Process Cube on 64bit Server with DTS package, lancemc5
- Re: Unable to Process Cube on 64bit Server with DTS package, Joel Leong
- Re: Unable to Process Cube on 64bit Server with DTS package,
lancemc5
- Re: Unable to Process Cube on 64bit Server with DTS package,
Jesse O
- Distinct count question,
Tim Graham
- Re: Distinct count question,
Deepak Puri
- Re: Distinct count question,
Tim Graham
- Re: Distinct count question, Tim Graham
- Re: Distinct count question,
Tim Graham
- Re: Distinct count question, Michael Vardinghus
- Re: Distinct count question,
Deepak Puri
- Budgeting and planning appliactions, Michael Vardinghus
- Move Analysis Services database,
Hassan
- Re: Move Analysis Services database,
Dave Wickert [MSFT]
- Re: Move Analysis Services database,
Hassan
- Re: Move Analysis Services database, Dave Wickert [MSFT]
- Re: Move Analysis Services database,
Hassan
- Re: Move Analysis Services database,
Dave Wickert [MSFT]
- Cube building from text / data files,
Prasad
- Re: Cube building from text / data files,
Dave Wickert [MSFT]
- Re: Cube building from text / data files,
Prasad
- Re: Cube building from text / data files, Dave Wickert [MSFT]
- Re: Cube building from text / data files,
Prasad
- Re: Cube building from text / data files, Dave Wickert [MSFT]
- Re: Cube building from text / data files, Prasad
- Re: Cube building from text / data files, Dave Wickert [MSFT]
- Re: Cube building from text / data files,
Prasad
- RE: Cube building from text / data files,
Prasad
- Re: Cube building from text / data files, Dave Wickert [MSFT]
- Re: Cube building from text / data files,
Dave Wickert [MSFT]
- AGE / Birthdate,
Tonni Schmücker
- Re: AGE / Birthdate,
Francesco Anti
- Re: AGE / Birthdate,
Tonni Schmücker
- Re: AGE / Birthdate, Francesco Anti
- Re: AGE / Birthdate,
Tonni Schmücker
- Re: AGE / Birthdate,
Francesco Anti
- Improving of MDX with NON EMPTY and WHERE whith calculated member, Ondrej Srubar
- YTD question, Galactico
- Processor usage,
Joppe
- Re: Processor usage,
Nigel Pendse
- Re: Processor usage, Dave Wickert [MSFT]
- Re: Processor usage,
Nigel Pendse
- Data Warehouse Design: A chanllenge question, DNG
- Current Date,
Steven Faith
- Re: Current Date,
Deepak Puri
- Re: Current Date, OLAPMonkey
- Re: Current Date,
Deepak Puri
- Re: How to browse my cube via IE?, Sridhar
- Cumulative Range,
Mangorind
- Re: Cumulative Range,
Deepak Puri
- Re: Cumulative Range,
Mangorind
- Re: Cumulative Range, Deepak Puri
- Re: Cumulative Range,
Mangorind
- Re: Cumulative Range,
Deepak Puri
- Problem with Custom Rollup formula in MDX query, USDOLAP via SQLMonster.com
- Max # of threads - Need Direction,
Prasad
- Re: Max # of threads - Need Direction, David Botzenhart
- RE: Max # of threads - Need Direction, Prasad
- What are latest initiatives for BI from Microsoft?,
James Woo via SQLMonster.com
- Re: What are latest initiatives for BI from Microsoft?,
Jacco Schalkwijk
- Re: What are latest initiatives for BI from Microsoft?,
James Woo via SQLMonster.com
- Re: What are latest initiatives for BI from Microsoft?, Thomas Ivarsson
- Re: What are latest initiatives for BI from Microsoft?, OLAPMonkey
- Re: What are latest initiatives for BI from Microsoft?, James Woo via SQLMonster.com
- Re: What are latest initiatives for BI from Microsoft?,
James Woo via SQLMonster.com
- Re: What are latest initiatives for BI from Microsoft?,
Jacco Schalkwijk
- MSSQLserverOlapsService terminates,
jerome
- Re: MSSQLserverOlapsService terminates, David Botzenhart
- Creating Virtual Dimensions through DSO,
Malcolm Toon
- Re: Creating Virtual Dimensions through DSO, David Botzenhart
- New OLAP TreeMap Report available for Microsoft Analysis Services 2000, olap
- HTTP/HTTPS Connectivity to Analysis Services,
Simon Kirk
- Re: HTTP/HTTPS Connectivity to Analysis Services,
David Botzenhart
- Re: HTTP/HTTPS Connectivity to Analysis Services, Simon Kirk
- Re: HTTP/HTTPS Connectivity to Analysis Services,
David Botzenhart
- Parllel partitions processing - Performance degradation.,
Prasad
- Re: Parllel partitions processing - Performance degradation., David Botzenhart
- Question about migrating BI Accelerator Files,
billd
- Re: Question about migrating BI Accelerator Files, Dave Wickert [MSFT]
- Cannot Connect to the Repository, Diane
- Best way to create linked cubes, Malcolm Toon
- Re: Delphi and OLAP, Malcolm Toon
- "cannot find dimension member" before I browse the dimension level?, lee
- Urgent! How to compare measure values between two periods?, Polly
- Wrong Aggregation Value when using MOLAP or HOLAP, donna
- managing role problem- bad repository?, Radu Colceriu
- ADOMD.NET Tutorials needed, SantanuM
- REMINDER TO EVERYONE: SQL Server 2000 SP4,
Dave Wickert [MSFT]
- Re: REMINDER TO EVERYONE: SQL Server 2000 SP4,
Deepak Puri
- Re: REMINDER TO EVERYONE: SQL Server 2000 SP4, Dave Wickert [MSFT]
- Re: REMINDER TO EVERYONE: SQL Server 2000 SP4,
Deepak Puri
- next member on axis, yaniv
- SQL DTS package to process a remote OLAP database, serge
- DSO/XML Conversion Utility error,
Jesse O
- Re: DSO/XML Conversion Utility error,
Dave Wickert [MSFT]
- Re: DSO/XML Conversion Utility error,
Jesse O
- Re: DSO/XML Conversion Utility error, Dave Wickert [MSFT]
- Re: DSO/XML Conversion Utility error,
Jesse O
- Re: DSO/XML Conversion Utility error,
Dave Wickert [MSFT]
- Deploying cubes from dev to prod,
Jesse O
- Re: Deploying cubes from dev to prod, Dave Wickert [MSFT]
- Create time sets - optimzied - Urgent !!!!, Sanjay
- Restoring AS - how to,
Jesse O
- Re: Restoring AS - how to, Dave Wickert [MSFT]
- virtual cubes,
Peter Feakins
- Re: virtual cubes, Deepak Puri
- 64 bit POC,
Prasad
- Re: 64 bit POC,
Deepak Puri
- Re: 64 bit POC, Dave Wickert [MSFT]
- Re: 64 bit POC,
Deepak Puri
- Re: Fairly Large Cube-Performance Improvement recommendations, BigJimSlade
- Analysis Services Standard Edition over internet, Bum
- Yukon AS2005 Etherogeneous data sources in DSV, Vania
- How to process a dimension without refreshing partition definition,
Ondra Srubar
- Re: How to process a dimension without refreshing partition definition, Dave Wickert [MSFT]
- OLAP Service crashes and hangs on restart, DRW - Cemex UK
- problem with creating local cube,
Andrej Hudoklin
- Re: problem with creating local cube, Tim Peterson
- Cannot find dimension member - in a name-binding funct,
Jonathan Levine
- Re: Cannot find dimension member - in a name-binding funct,
Deepak Puri
- Re: Cannot find dimension member - in a name-binding funct,
Jonathan Levine
- Re: Cannot find dimension member - in a name-binding funct, Jonathan Levine
- Re: Cannot find dimension member - in a name-binding funct, Jonathan Levine
- Re: Cannot find dimension member - in a name-binding funct,
Jonathan Levine
- Re: Cannot find dimension member - in a name-binding funct,
Deepak Puri
- Multiple dimension order() and rank(),
mdxwhip
- Re: Multiple dimension order() and rank(),
Deepak Puri
- Re: Multiple dimension order() and rank(),
mdxwhip
- Re: Multiple dimension order() and rank(), Deepak Puri
- Re: Multiple dimension order() and rank(),
mdxwhip
- Re: Multiple dimension order() and rank(),
Deepak Puri
- MDX filter help,
Sam
- Re: MDX filter help, Deepak Puri
- Anything in the bin folder that should be backed up?, Jesse O
- Access to AS over HTTP failing accross domains,
Codecommando
- Re: Access to AS over HTTP failing accross domains,
BigJimSlade
- Re: Access to AS over HTTP failing accross domains,
Codecommando
- Re: Access to AS over HTTP failing accross domains, Dave Wickert [MSFT]
- Re: Access to AS over HTTP failing accross domains, Codecommando
- Re: Access to AS over HTTP failing accross domains,
Codecommando
- Re: Access to AS over HTTP failing accross domains,
BigJimSlade
- Re: Semiadditive measures, MDX, really need help,
Andrew Alfaro via SQLMonster.com
- Re: Semiadditive measures, MDX, really need help,
Deepak Puri
- Re: Semiadditive measures, MDX, really need help,
Andrew Alfaro via SQLMonster.com
- Re: Semiadditive measures, MDX, really need help, Deepak Puri
- Re: Semiadditive measures, MDX, really need help, Andrew Alfaro via SQLMonster.com
- Re: Semiadditive measures, MDX, really need help,
Andrew Alfaro via SQLMonster.com
- Re: Semiadditive measures, MDX, really need help,
Deepak Puri
- How to properly restore AS,
Jesse O
- RE: How to properly restore AS,
SQL McOLAP
- Re: How to properly restore AS,
Jesse O
- Re: How to properly restore AS, SQL McOLAP
- Re: How to properly restore AS,
Jesse O
- RE: How to properly restore AS,
SQL McOLAP
- Consolidate set members,
smccall
- Re: Consolidate set members, Deepak Puri
- Crossjoins between different cubes, Andrea Temporin
- How to categorize customers, Jeff Loh
- duplicate names, GuyR
- Re: Authentication for access to an Olap Cube via HTTP, John Jayaseelan
- Analysis Services "connection lost" errors, Ramanand
- MDX - Non Empty Cells for each member of a dimension, PT
- Analysis Server Properties,
Hassan
- Re: Analysis Server Properties, Dave Wickert [MSFT]
- formula error-cannot find dimension member in a name binding function, akshab
- Creating optimized time sets,
Sanjay
- Re: Creating optimized time sets,
Deepak Puri
- Re: Creating optimized time sets,
Sanjay
- Re: Creating optimized time sets, Deepak Puri
- Re: Creating optimized time sets, Sanjay
- Re: Creating optimized time sets,
Sanjay
- Re: Creating optimized time sets,
Deepak Puri
- Drill Down with MDX & VBA,
Rodrigo
- <Possible follow-ups>
- Drill Down with MDX & VBA, Rodrigo
- Adding exchange rates.,
Patrick Flaherty
- Re: Adding exchange rates.,
Thomas Ivarsson
- Re: Adding exchange rates., Thomas Ivarsson
- Re: Adding exchange rates.,
Patrick Flaherty
- Re: Adding exchange rates., Patrick Flaherty
- Re: Adding exchange rates., Thomas Ivarsson
- Re: Adding exchange rates., Patrick Flaherty
- Re: Adding exchange rates.,
Thomas Ivarsson
- Openquery fails on Windows Server 2003, Steve Hughes
- Analysis Server Temporary File Folder location,
Len Gustafson
- Re: Analysis Server Temporary File Folder location, David Botzenhart
- Using Member Properties in Calculated Measures,
davidb@xxxxxxxxxxxxxxx
- Re: Using Member Properties in Calculated Measures, davidb@xxxxxxxxxxxxxxx
- Problem Urgent!!,
Francisco Birrer
- Re: Problem Urgent!!,
Bill Hays
- Re: Problem Urgent!!,
Francisco Birrer
- Re: Problem Urgent!!, Bill Hays
- Re: Problem Urgent!!, Francisco Birrer
- Re: Problem Urgent!!,
Francisco Birrer
- Re: Problem Urgent!!,
Bill Hays
- hitting the 64k limit with a hierarchial big dimension - Please ad,
Prasad
- Re: hitting the 64k limit with a hierarchial big dimension - Please ad,
David Botzenhart
- Re: hitting the 64k limit with a hierarchial big dimension - Please ad, Dave Wickert [MSFT]
- Re: hitting the 64k limit with a hierarchial big dimension - Please ad,
David Botzenhart
- When to use Microsoft Data Analyzer or Proclarity - Nigel please comment, karenmiddleol
- Dimension Reporting not cube reporting,
karenmiddleol
- Re: Dimension Reporting not cube reporting,
James Woo via SQLMonster.com
- Re: Dimension Reporting not cube reporting,
karenmiddleol
- Re: Dimension Reporting not cube reporting, Dave Wickert [MSFT]
- Re: Dimension Reporting not cube reporting, James Woo via SQLMonster.com
- Re: Dimension Reporting not cube reporting,
karenmiddleol
- Re: Dimension Reporting not cube reporting,
James Woo via SQLMonster.com
- Analysis Server Error: File error [Write error] There is not enough space on the disk, mmajorza52
- CellSetGrid error help needed,
Terry
- Re: CellSetGrid error help needed,
Richard Tkachuk [MSFT]
- Re: CellSetGrid error help needed,
Terry
- Re: CellSetGrid error help needed, QuanChi66
- Re: CellSetGrid error help needed, Richard Tkachuk [MSFT]
- Re: CellSetGrid error help needed, QuanChi66
- Re: CellSetGrid error help needed, Richard Tkachuk [MSFT]
- Re: CellSetGrid error help needed,
Terry
- Re: CellSetGrid error help needed,
Richard Tkachuk [MSFT]
- Displaying Calculated Members on webpage causes system hang/crash, Poobalan
- Displaying Calculated Members causes system to hang/crash, Poobalan
- Connection problems across domains,
Malcolm Toon
- Re: Connection problems across domains,
Dave Wickert [MSFT]
- Re: Connection problems across domains,
Malcolm Toon
- Re: Connection problems across domains, Dave Wickert [MSFT]
- Re: Connection problems across domains,
Malcolm Toon
- Re: Connection problems across domains,
Dave Wickert [MSFT]
- Front-Ends,
Malcolm Toon
- Re: Front-Ends, Radu Colceriu
- Re: Front-Ends,
duvinrouge
- Re: Front-Ends,
Jesse O
- Re: Front-Ends, mps
- Re: Front-Ends,
Jesse O
- How to put the prompt in connectionstring in OWC to access HTTP,
Claudio
- Re: How to put the prompt in connectionstring in OWC to access HTTP, Dave Wickert [MSFT]
- SQL Server 2000 Analysis Job Error,
Daniel Castro
- Re: SQL Server 2000 Analysis Job Error,
David Botzenhart
- Re: SQL Server 2000 Analysis Job Error,
Daniel Castro
- Re: SQL Server 2000 Analysis Job Error, Daniel Castro
- Re: SQL Server 2000 Analysis Job Error,
Daniel Castro
- Re: SQL Server 2000 Analysis Job Error,
David Botzenhart
- Any idea about this error?,
Jesse O
- Re: Any idea about this error?,
David Botzenhart
- Re: Any idea about this error?, Jesse O
- Re: Any idea about this error?,
David Botzenhart
- Re: URGENT : CRASH on Analysis Services SQL Server 2000 on PRODUCT,
Japm
- Re: URGENT : CRASH on Analysis Services SQL Server 2000 on PRODUCT, David Botzenhart
- Archive and backing up cube strategy,
Jesse O
- Re: Archive and backing up cube strategy, David Botzenhart
- Re: Fast Track to MDX - next version,
Gautham Kamath via SQLMonster.com
- Re: Fast Track to MDX - next version,
Mosha Pasumansky [MS]
- Re: Fast Track to MDX - next version,
Gautham Kamath via SQLMonster.com
- Re: Fast Track to MDX - next version, Mosha Pasumansky [MS]
- Re: Fast Track to MDX - next version,
Gautham Kamath via SQLMonster.com
- Re: Fast Track to MDX - next version,
Mosha Pasumansky [MS]
- Problems using MS OLAP,
Japm
- Re: Problems using MS OLAP,
David Botzenhart
- Re: Problems using MS OLAP,
Japm
- Re: Problems using MS OLAP, David Botzenhart
- Re: Problems using MS OLAP, Japm
- Re: Problems using MS OLAP,
Japm
- Re: Problems using MS OLAP,
David Botzenhart
- Number of cubes and processing time,
Stanley
- Re: Number of cubes and processing time, David Botzenhart
- OLAP drillthough too finely detailed,
seema
- Re: OLAP drillthough too finely detailed, David Botzenhart
- SP4 ? connection string bug,
Radu Colceriu
- Re: SP4 ? connection string bug, David Botzenhart
- drilltrough in excel2003,
verbani
- Re: drilltrough in excel2003,
David Botzenhart
- Re: drilltrough in excel2003, verbani
- Re: drilltrough in excel2003,
David Botzenhart
- Partition Data not shown,
Michael Roedeske
- RE: Partition Data not shown, SQL McOLAP
- filtering on a dimension member, Carlos
- Re: Cube 100% online, Mohd Sufian
- Where Clause in Create Cube,
Ernesto LEITE via SQLMonster.com
- Re: Where Clause in Create Cube, Ernesto LEITE via SQLMonster.com
- Process cube through programming,
Mohd Sufian
- RE: Process cube through programming,
Nin
- RE: Process cube through programming, Mohd Sufian
- RE: Process cube through programming,
Nin
- RE: Data Analyzer color scale window incorrect behavior, Lada Dvorak
- Slow running COUNT CROSSJOIN query, joshuairwin
- Re: level display issue -1.#INF(in OLAP) and #NUM!(IN XP Pivot), urgent
- How to get a constant string in a calculated measure, urgent
- Re: Users not in Administrators gruoup can't login to AS,
Carlos Gutierrez
- Re: Users not in Administrators gruoup can't login to AS,
Monte
- Re: Users not in Administrators gruoup can't login to AS,
Carlos Gutierrez
- Re: Users not in Administrators gruoup can't login to AS, Monte
- Re: Users not in Administrators gruoup can't login to AS, Dave Wickert [MSFT]
- Re: Users not in Administrators gruoup can't login to AS, Carlos Gutierrez
- Re: Users not in Administrators gruoup can't login to AS,
Carlos Gutierrez
- Re: Users not in Administrators gruoup can't login to AS,
Monte
- why no Grand total for calculated dimension meaure?, urgent
- Re: Percent to Total calculated measure for multiple levels in a dimension?, mdxwhip
- How to determine a candidate project for OLAP,
saleyoun
- Re: How to determine a candidate project for OLAP, Michael Vardinghus
- iif question on calculated dimension,
urgent
- Re: iif question on calculated dimension, Mosha Pasumansky [MS]
- RE: iif question on calculated dimension, Nin
- Create Cube Where Clause,
Ernesto LEITE via SQLMonster.com
- Re: Create Cube Where Clause,
Eleazar
- Re: Create Cube Where Clause, Ernesto LEITE via SQLMonster.com
- Re: Create Cube Where Clause, Ernesto LEITE via SQLMonster.com
- Re: Create Cube Where Clause,
Eleazar
- Adding RAM above 3 GB with 64bit platform to improve performance,
ptaylor
- Re: Adding RAM above 3 GB with 64bit platform to improve performance, Dave Wickert [MSFT]
- RE: Adding RAM above 3 GB with 64bit platform to improve performance, Chris Webb
- Re: MDX Solutions Second Edition,
Peter Zajkowski via SQLMonster.com
- Re: MDX Solutions Second Edition,
Chris Webb
- Re: MDX Solutions Second Edition, Peter Zajkowski via SQLMonster.com
- <Possible follow-ups>
- RE: MDX Solutions Second Edition, Vania
- Re: MDX Solutions Second Edition,
Chris Webb
- OLAP OLEDB Client Slow to Connect,
Mark
- Re: OLAP OLEDB Client Slow to Connect, Dave Wickert [MSFT]
- Issue with Cube Building because of Dimension filters,
Prasad
- Re: Issue with Cube Building because of Dimension filters, Dave Wickert [MSFT]
- MDX Create Member / Drop Member problem,
Michel CARADEC
- Re: MDX Create Member / Drop Member problem, Mosha Pasumansky [MS]
- The query could not be processed: o the cube name 'xxxxxx' is inva, Ricardo Narezi
- read only, Christine Molina
- Problem Excel 2000 with Distinct Count in OLAP-measure,
Hans
- Re: Problem Excel 2000 with Distinct Count in OLAP-measure, Mosha Pasumansky [MS]
- Aggregating measures from the first period in the cube., GunnarKarlsson
- Urgent - No reply,
Sandro
- Re: Urgent - No reply, Mosha Pasumansky [MS]
- Write back using weighted allocation,
Michael Broede
- Re: Write back using weighted allocation,
Mosha Pasumansky [MS]
- Re: Write back using weighted allocation, Michael Broede
- Re: Write back using weighted allocation,
Mosha Pasumansky [MS]
- Re: role creation / changes tahke more than 10min,
Radu Colceriu
- Re: role creation / changes tahke more than 10min,
minimax
- Re: role creation / changes tahke more than 10min, Radu Colceriu
- Re: role creation / changes tahke more than 10min,
minimax
- Error dimension on CRM database, Christine Molina
- RE: problem to always display all members of a dimension in XP piv, Nin
- Re: Struggling with grouping results in Excel / Analysis Services, Deepak Puri
- Re: how ans where MDX should be used..., Deepak Puri
- Re: Alternate hierachies on the same dimension,
Thomas Ivarsson
- Re: Alternate hierachies on the same dimension,
Michael Vardinghus
- Re: Alternate hierachies on the same dimension, Thomas Ivarsson
- Re: Alternate hierachies on the same dimension,
Michael Vardinghus
- What is maximum size of a cube? Can a cube span a physical disk?,
goyald
- Re: What is maximum size of a cube? Can a cube span a physical disk?, Thomas Ivarsson
- Re: What is maximum size of a cube? Can a cube span a physical disk?, Michael Vardinghus
- Re: What is maximum size of a cube? Can a cube span a physical disk?, Dave Wickert [MSFT]
- Re: Filtering using member key in mdx query,
Deepak Puri
- <Possible follow-ups>
- Re: Filtering using member key in mdx query, Gautham Kamath via SQLMonster.com