Extended metadata --> XMD
How to change formatting and other factors using XMD.
For making changes using XMD you need to use a utility on Github. Datasetutils-32.x.x is what its called.
The zip file has run.bat for windows users.
Open and use the same credentials as your org. Sign in to app and you can see the dataflow list, file upload, process monitor and XMD.
Click the actions on a dataset and edit XMD.
You can see the json now.
There are key value pairs like JSON.
The one of the right is the label and the left value is the API Name.
If you want to change the Labels you can change the XMD and look at the data set you can see the changes reflected there.
It will show the errors on run time with an x on the side bar in red.
When you click submit XMD you can see if it worked successfully.
You can rename measures just like renaming dimensions.
Date is splits in different grains of time.
The composite date dimension combines all the grains of time and gives on value of time.
Let us say you are extracting 50-60 users from the system, you want the end user to see only a few. You can do this from the XMD.
Use "hide_dimensions":[api names of the dimensions you want to hide in quotes]
Click submit xmd and you will see the change.
Using xmd you can format values on a dashboard.
Go the section named formats.
Go to the measure you are interested in.
It takes 2 parameters
"$",##0.00"
This means you want to see the value from
30000 to $30000.00
How to add formatting to a derived measure?
YoY [#,##0.00"%"]
We can relabel the values for dimensions using XMD. We can give colors for that also. Below is given how it is done.
Go to the colors and give for 0 and 1.
To rename 0 and 1 use
Cancelled here is the dimension name.
"keys":{
"Cancelled":{
"0":Yes
"1":No}
}
Value query columns
No comments:
Post a Comment