Identifying Level 0 in metadata export

A level 0 member will not appear in the parent column.

Cheers

John

Hahahah - nice find John! (I'd read that post as well, just hadn't put 2 and 2 together!)

To the OP - here's some hacked together Powershell that will generate a list of level 0 members.

$Username = {User} #replace with username

$Password = {Password} #replace with password

$URL = {URL} <# in format "https://planning-test-<domain>.pbcs.<env>.oraclecloud.com" #>

$Domain = $Domain #Replace with domain

$AppName = "Demo" #replace with the app name

$Dim = "Entity" #replace with the dimension you want

$Filename = "F:\PBCS_REST\Entity_Dim_Lev0.csv" #replace with an output file

# Convert creds to auth headers

$Enc_Auth = [System.Text.Encoding]::UTF8.GetBytes(("{0}.{1}:{2}" -f $Domain, $Username, $Password))

$Enc_PW = [System.Convert]::ToBase64String($Enc_Auth)

$PBCS_REST_URL = "{0}/aif/rest/V1/applications/{1}/dimension/{2}/" -f $URL, $Appname, $Dim

# Trigger the Dim Function

    try{

        $DimDetails = Invoke-RestMethod -Uri $PBCS_REST_URL -Method GET -Headers @{"Authorization"="Basic $($Enc_PW)"} -ContentType "application/json"

        $DimDetails.items | Where-Object {$_.childCount -eq "0"} | select memberName -Unique | ConvertTo-Csv > $Filename -NoTypeInformation

        write-host "Created dimensional list: $Filename"

    }

Catch {throw $_.Exception.Message}

Gives you a nice little list.

Hi,

Download Planning admin extension from PBCS  downloads and install it. through this extension you can access your dimensions through smartview. once you connect your application through smartview you can see dimensions as below.

select the dimension and right click on dimension name and select edit

In Ad hoc ribbon page you have an option called Zoom in .

select Zoom in to bottom level which will give you all level 0 members with parents.

Thanks.