Analysis Services

• Topics

  Started by

  Posts

  Last post

• Cannot create an instance of OLE DB provider "MICROSOFT.ACE.OLEDB.12.0" for linked server "(null)".

  error message: Cannot create an instance of OLE DB provider "MICROSOFT.ACE.OLEDB.12.0" for linked s…

  Andrew Pankov

  3 replies

  10 years, 9 months ago

  By: Jeff Moden

• Querying SCD Type 2 data to determine current value & date of change for a value that changes back and forth.

  The subject kind of spells out what I am looking for. Attached is an example table image of an exa…

  touchupboy

  1 replies

  10 years, 9 months ago

  By: Martin Schoombee

• Dimension Members showing Empty in Excel

  Good Day All. I am hoping this is not a bizarre or vague topic but its totally weird on my end. So…

  ttdeveloper

  11 replies

  10 years, 9 months ago

  By: ttdeveloper

• Using Scoped Assignments To Show Calendar Year-To-Date Values

  I have a problem when I write scopes statement to calculate Calendar Year-To-Date Values in cube us…

  hieupm.it90

  2 replies

  10 years, 9 months ago

  By: Martin Schoombee

• Dynamic Security in a denormalized Parent-Child dimension Table

  Hi guys, I need your priceless help again: I have a parent child relationship in a table with a fix…

  Paul Hernández

  1 replies

  10 years, 9 months ago

  By: Martin Schoombee

• Giving non sa users select access to cubes?

  Hi All, I have been searching high and low and cant find how to solve this problem i have with ssas…

  BTB

  4 replies

  10 years, 9 months ago

  By: Martin Schoombee

• can i open an analysis services database in BIDs

  Hi I have access to an analysis services database in management studio. Is it possible for me to o…

  erics44

  11 replies

  10 years, 10 months ago

  By: gward 98556

• filtering using strtoset

  Hi, i have the following MDX query that uses parameters from an SSRS report to produce a result set…

  scottcabral

  11 replies

  10 years, 10 months ago

  By: scottcabral

• Setting IsAggregatable to False on dimension attributes causes problems

  I have a fairly simple dimension with 4 attributes all linked to a surrogate key. It doesnt make se…

  Aliflair

  3 replies

  10 years, 10 months ago

  By: RonKyle

• Basic MDX listing by date

  Hi I have written this MDX select {[Date].[Calendar Year].[2014], [Date].[Calendar Year].[2015]} on…

  erics44

  1 replies

  10 years, 10 months ago

  By: Martin Schoombee

• Querying Across Measure Groups in SSAS (Can it be done?)

  I'm fairly new to the world of SSAS, but have been around the relational side of data warehousing f…

  jjbear11

  1 replies

  10 years, 10 months ago

  By: Martin Schoombee

• Working out percentages on group - How to

  HI folks, I need some help desperately. I am very new to report builder 3.0 and have never written …

  paul.smith2

  3 replies

  10 years, 10 months ago

  By: paul.smith2

• SSAS hierarchy change

  I have a user-defined hierarchy in my cube that goes: [font="Courier New"]Region --> State -->…

  robert.gerald.taylor

  3 replies

  10 years, 10 months ago

  By: PB_BI

• MDX Add a Total member in the query

  Hi Experts, I have a mdx query that give me headach. I have an hierarchy Clients like this Region -…

  Lidou123

  6 replies

  10 years, 10 months ago

  By: Martin Schoombee

• SSAS CUBE PROCESSING ERROR

  I am new bie trying to learn SSAS. I have these errors in trying to process my cube after it has sh…

  eobiki10

  21 replies

  10 years, 10 months ago

  By: dscott_msc