Does xViz support ESSBASE as a datasource?
I installed the xViz Hierarchy Filter and was able to load my filter with data.
(Using Oracle’s ESSBASE as my data source)
However when I apply the filter to other tables, I get the following error
Thanks so much for your time!
BatCat
Query(2, 3) Column [Table.[Dimension].Level 1] is part of a composite key, but not all columns of the composite key are included in the expression or its dependent expression Feedback Type: Frown (Error) Timestamp: 2019-12-11T19:19:43.2897611Z Local Time: 2019-12-11T14:19:43.2897611-05:00 Session ID: 25ddb41a-d0a8-453b-9558-fdca001c77aa Release: September 2019 Product Version: 2.73.5586.561 (19.09) (x86) Error Message: Query(2, 3) Column [Table.[Dimension].Level 1] is part of a composite key, but not all columns of the composite key are included in the expression or its dependent expression OS Version: Microsoft Windows NT 10.0.16299.0 (x64 en-US) CLR Version: 4.7 or later [Release Number = 461814] Peak Virtual Memory: 1.55 GB Private Memory: 492 MB Peak Working Set: 510 MB IE Version: 11.1451.16299.0 User ID: 0913e4da-a651-4ab6-8971-16ed7281017a Workbook Package Info: 1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True. Telemetry Enabled: True Model Default Mode: DirectQuery Snapshot Trace Logs: C:\private\Power BI Desktop\FrownSnapShot1218600045.zip Performance Trace Logs: C:\private\Power BI Desktop\PerformanceTraces.zip Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_NewWebTableInference PBI_showIncrementalRefreshPolicy PBI_qnaLiveConnect PBI_userFavoriteResourcePackagesEnabled PBI_tenantOutOfBoxVisualsEnabled PBI_personalVisualizationPaneEnabled Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 100% Supported Services: Power BI Formulas: section Section1; shared Cube = let Source = Essbase.Cubes("secret address"), testessbase1 = Source{[Name="testessbase1"]}[Data], Cube1 = testessbase1{[Name="Cube1"]}[Data], Cube1.Cube1 = Cube1{[Name="Cube1.Cube1"]}[Data], #"Added Items" = Cube.Transform(Cube1.Cube1, { }), AddUniqueIds = let CreateNewDimensions = (cube) => Table.TransformColumns(Cube.Dimensions(cube), { "Data", (dimTable) => let FieldTypes = Type.RecordFields(Type.TableRow(Value.Type(dimTable))) in List.Accumulate( Table.ColumnNames(dimTable), dimTable, (table, column) => if (Value.Metadata(Record.Field(FieldTypes, column)[Type])[Cube.GroupByKey]? <> null) then table else Table.AddColumn(table, column & ".UniqueId", each Cube.AttributeMemberId(Record.Field(_, column)))) }), NewCube = Cube.ReplaceDimensions(#"Added Items", CreateNewDimensions) in NewCube in AddUniqueIds;
Question is closed for new answers.
Dharani Selected answer as best