Get Free Trial

Graph implementation

Answered
Nil asked on November 11, 2021

Hi Team,
We are reading data from AAS.
We need to implement the attached graph there Msr1,Msr2,Msr3 are the measure and it should break by 
Client A,B,C and Timeframes ex. Jan-2021,Feb-2021
 
please let us help with what need to mention in rows ,measure etc

Attachments:
OFFQMC.png

5 answers

Public
Vera Didenko Vera Didenko Flexmonster November 11, 2021

Hello, Nil,
 
Thank you for writing to us.
 
To create the same graph as on the screenshot in Flexmonster, you need to place the mentioned fields in the following slice sections:

  • place the "Client" and "Timeframes" fields in "rows";
  • place "Msr1", "Msr2", and "Msr3" in "measures";

 
For example, the slice in your report configuration should resemble the following:

"slice": {
"rows": [
{ "uniqueName": "[Client]" },
{ "uniqueName": "[Timeframes]" }
],
"columns": [
{ "uniqueName": "[Measures]" }
],
"measures": [
{ "uniqueName": "[Measures].[Msr1]" },
{ "uniqueName": "[Measures].[Msr2]" },
{ "uniqueName": "[Measures].[Msr3]" }
]
}

Also, to display multiple measures on the chart, please set the "multipleMeasures" chart option to true, for example:

"options": {
"viewType": "charts",
"chart": {
"multipleMeasures": true
}
},

 
We prepared a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/yobwe83c/.
 
Please let us know if this helps.
Waiting for your response.
 
Kind regards,
Vera

Public
Nil November 15, 2021

Hi Team,
We have apply the same as you said above format.
Is it not possible to do with without expand 
Kindly check and update 

Public
Vera Didenko Vera Didenko Flexmonster November 15, 2021

Hello, Nil,
 
Thank you for your response.
 
Yes, it is possible to expand all data on the chart by default. You can achieve this by specifying the expands.expandAll slice property

slice: {
...

"expands": {
expandAll: true
}
}

We have updated the example accordingly: https://jsfiddle.net/flexmonster/fa2p4eyv/.
 
Please let us know if this helps.
 
Kind regards,
Vera

Public
Nil November 15, 2021

public pivotReport = {
dataSource: {
type: “microsoft analysis services”,
/* URL to Flexmonster Accelerator */
proxyUrl: environment.flexmosterAccelerator,
/* Catalog name */
catalog: environment.catalog,
/* Cube name */
cube: environment.cube,
// Flag to use the Accelerator instead of XMLA protocol binary
binary: true
},
slice: {
reportFilters: [
{
“uniqueName”: “[Customer].[CustomerID]”,
“filter”: {
“members”: [
“[Customer].[CustomerID].&[C1]”
, “[Customer].[CustomerID].&[C2]”
, “[Customer].[CustomerID].&[C3]”,
“[Customer].[CustomerID].&[C4]”
]
}
}, {
“uniqueName”: “[Project].[ProjectID]”
, “filter”: {
“members”: [
“[Project].[ProjectID].&[P1]”,
“[Project].[ProjectID].&[P2]”,
“[Project].[ProjectID].&[P3]”,
“[Project].[ProjectID].&[P4]”

]
}
}
],
rows: [
{
“uniqueName”: “[Customer].[CustomerName]”,
caption: “Customer Name”
},
{
“uniqueName”: “[Calendar].[MMDDYYYY]”
}
],
columns: [
{
“uniqueName”: “[Breakdown].[Type]”,
“filter”: {
“exclude”: [
“[Breakdown].[Type].&”
]
}
},
{
uniqueName: “[Measures]”
}
],
measures: [
{
“uniqueName”: “[Measures].[Measure1]”,
caption: “Measure1 Name”
}
],
“expands”: {
expandAll: true
}
},
options: {
viewType: “charts”,
chart: {
type: “bar”,
title: “Bar Chart “,
showFilter: true,
multipleMeasures: true,
showDataLabels: true,
oneLevel: true,
showLegend: true,
showLegendButton: true,
showMeasures: true,
}
},
};
 
this is i am referring in our development , but it wont work for me ,please check it on AAS as data source  

Public
Vera Didenko Vera Didenko Flexmonster November 16, 2021

Hello, Nil,
 
Thank you for sharing your report configuration.
 
In your report configuration, we noticed that you are using the oneLevel chart option.
The oneLevel chart option prevents the chart from displaying all expanded data at once.
To show all expanded data at once, please remove or disable the oneLevel chart option:

options: {
viewType: "charts",
chart: {
 multipleMeasures: true,
oneLevel: false
}
}

 
Please let us know if this helps.
 
Kind regards,
Vera

Please login or Register to Submit Answer