Does xViz support ESSBASE as a datasource?

1.52K views
0

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;

Answered question
0

Hello,

xViz supports all the data sources that are supported by the Microsoft Power BI

Thanks,

Dharani

Answered question
You are viewing 1 out of 2 answers, click here to view all answers.