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
⋅ 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:
"Client" and "Timeframes" fields in "rows";"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
⋅ 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
⋅ 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
⋅ 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
⋅ 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