Update
Think I have resolved this for now.
I went back to our development server, updated the dimension with the latest master data refresh, updated all attributes, rebuilt all rollups, rebuilt all alternate hierarchies and verified structures.
I noticed that there were quite a few items not in the Default hierarchy but appearing in the Leave hierarchy. These "orphaned" items looked to be old members from testing, previous loads etc. It is possible that the members were removed from the Default hierarchy via a deletion from the dimension in Perspectives. (Still need to check if this causes the member to be deleted from the default but kept in Leaves).
I created some MDX to go through members in Leaves and not in the Default hierarchy, and delete them.
This cleaned up the orphaned/ unused members and the two hierarchies seem more aligned.
After a save data, I copied over the Product dimension and the hierarchies from the Product}hiers to Production.
So far so good - PAfE giving DIMIX values where alias is used, TM1Web returning reports with values, not just a blank structure.
Still not sure what happened here or how to prevent it from happening again but would be happy if anyone has anything to add.
------------------------------
George Tonkin
------------------------------
Original Message:
Sent: Thu June 17, 2021 01:20 PM
From: George Tonkin
Subject: TM1Web-Dynamic Report not returning values but is returning structure
Hi, Wondering if anyone has experienced this strange issue.
I have a Product dimension with an Alias of Description. Description is a concatenation of the Product code and the description text, static from import, not rule derived.
Copying and pasting members into the Set editor with the Description Alias on or off pastes as expected and the members are valid.
If I create a Dynamic Report in PAfE with the Product on rows and Description on, the report rebuilds and shows values as expected:
------------------------------
George Tonkin
------------------------------
#PlanningAnalyticswithWatson