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

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top