olap

  1. C

    CUBEVALUE

    I brought in a table and loaded it to data model. I created a pivot and then used OLAP tools to convert it to Cube formulas (allowing me to insert columns, etc where a pivot table won't let you). My problem arises when I bring in the next month's data. I've written the formula that hould work...
  2. M

    Formatting OLAP Pivot Table Measures via VBA...

    Hi, Does anyone have any experience of applying formats to pivot table measures conditionally based on their name? For example, if my measure has a (£) in its name, then apply a currency format, else apply a simple numeric format. I've done this kind of thing successfully with ordinary pivot...
  3. J

    OLAP Pivot

    Hello, This is the 1st time I am working with OLAP Cube Pivots. Need help please. I have a OLAP Cube pivot that has years from 1900 to current year. However it is missing few years in between. I need to be able to select all the years except for the last 15 years (2004 to 2019 needs to be...
  4. M

    Olap cube f'lter'ng multiple items via vba

    Hi team, I have to filter more than 100 items to olap cube. I can't it manually, can i do this with vba ? the items are in a row (Q2:Q150) I want that vba add it to olap cube filter. I found a code, but doesn't work. sub test() Dim MyArray as variant Dim rcnt as Integer rcnt =...
  5. T

    Infinite OLAP Refresh Loop

    Good Afternoon, I have an excel workbook in which there is a pivot that is connected to power BI. When I attempt to refresh this pivot I get stuck in an infinite refresh loop forever. It just says the following things over and over again: Running OLAP query Refreshing the OLAP cube Waiting...
  6. G

    Macro to generate Pdf of all pivot table slicer items. Pivot table connected to OLAP cube.

    I've followed instructions on this thread : https://www.mrexcel.com/forum/excel-questions/982591-slicer.html, But it only works on a standalone pivot table, not one connected to an OLAP cube. Is there any way to generate Pdf files of a pivot table that's connected to an OLAP cube, based on...
  7. M

    OLAP Pivottable calculated column (mdx calculated measure?)

    Hello everyone, Below is a simplification of a pivvottable (OLAP!) I've created. I'm having trouble adding a column that shows the difference between the two periods I cannot use a calculated column because the source is OLAP/cube I cannot figure out how to use an MDX measure because there is...
  8. P

    Paste filter search values with OLAP

    I'm looking for a way to paste a list of values into a filter search on an OLAP pivot rather than click each value. I saw a way to do this years ago but cannot find it. I saw mention of an add-in, but not sure which one. - Pete
  9. J

    OLAP to Reference ListBox (Active X Control)

    I have =CUBEVALUE() functions referencing twenty Lists created with Data Validation (Bolded below). =CUBEVALUE("ThisWorkbookDataModel",$B$2,$B$3,$B$4,$B$5,$B$6,$B$7,$E$2,$E$3,$E$4,$E$5,$H$2,$H$3,$H$4,$K$2,$K$3,$K$4,$K$5,$N$2,$N$3,$H$7,$A$1,$A12,B$11) The limitation is that only one value per...
  10. S

    Excel Olap PowerPivot Filters

    When removing some field items from your pivot table based on an olap query, I noticed some filters automatically clear, where as others remain and you must find them on the field list and clear them manually. I'm not sure what the driver here is... does anyone have an idea? google has not...
  11. S

    Copy sheet with cube formulas to new book results in #NAME?

    Hi! all my previous question I found answers on on this forum, but on the following question I couldn't find any related topics: I'm trying to write a VBA code to copy paste 2 sheets of my workbook to a new book. So far no problem with VBA code below: Sub Button1_Click() With ThisWorkbook...
  12. E

    Olap filter on dates using VBA and custom Date filter

    Hello Mr Excel, I have a tricky VBA code I'm trying to figure out, but cannot quite get the code to recognize my code for the dates. I'll try to clarify my issue and show blogs I've tried. I've build a table that includes 12-20 dates in the format YYYY-PMM so "Year"- "P" (Period) and "month"...
  13. G

    OLAP Pivot, Pivot Item, Move To End

    Hello, I have an OLAP Pivot. There is a Value in one of the rows that I want to move to the end. The field is called "Top Customer", the value is "All Other". The vba recorder produces this: ActiveSheet.PivotTables("PivotTable3").PivotFields( _ "[Sales Org Hierarchy].[Top...
  14. M

    Pull Data from OLAP cube into separate pivot tables and then make into master pivot table

    I currently have a workbook designed that uses data from several reports within our POS system. The problem is I have to run reports and export to excel, merge some reports so they are in one clean table, then copy and paste into my workbook. From there my pivot tables automatically refresh...
  15. T

    Add multiple fields into Value area of (OLAP) pivot tables

    Hello members, I have just starting to write <acronym title="visual basic for applications">vba</acronym> code and would appreciate anyones help on this :smile: I have tried looking in various forums for the answers but to no success. I am currently running code as per below for a...
  16. R

    Run-time error '1004': Unable to get the PivotTables property of the Worksheet class

    Hi, I am trying to get a macro to run to automatically change the filters in a Pivot table linked to a Cube. I recorded the macro to begin with but I always get the error listed in the title of this thread. My code is: Sub CubeReconcile() Application.ScreenUpdating = False...
  17. R

    Pivot connect to SSAS OLAP cube - Dimension properties causing same value to display twice

    In my pivot table that is connected to a SSAS OLAP cube, I have a dimension with several values that are the same, but have two different values defined for the same property. For example, dimension value "ABCD" has a property 1 value of both "123" and "789". As a result of this, the pivot...
  18. V

    Filter OLAP pivot by list of items

    Hi there, I hope someone can help me. I really need to filter my pivot table based on OLAP cube with list of styles. Is there a way to do that? I would have a list of items in column b1:b10 and I expect that the filter gets updated anytime I change a value on in the list. Much appreciated with...
  19. W

    VBA PivotTable Field Properties

    The data I get from Corporate comes in as an OLAP PivotTable. Some of the Dimensions(Text Fields) have Properties associated with them. For example a Project has a "Project Name" and "Project Manager" property. In the PivotTable tools /Options ribbon there is an OLAP Tools drop down for Property...
  20. N

    Olap Pivot Table Vba Macro Help

    I have the code below that I got from another thread hear. It works great but I want to change my array. Currently I have to list each account number. Can I make it so that my array is linked to a name range. My name range can look like either of the Below. I want to filter my cube data in the...

Some videos you may like

This Week's Hot Topics

Top