Search results for query: *

Thanks again, I have found that I can add an outer join to the relationship within framework manager. I did this in the physical model relationship. This also applies to the DMR metadata too so problem solved. Just another q - is there a way to replace the null values with a zero ('0')? At...

Thanks for the reply. Is there a way to model the relationships between the dimensions and measures in the DMR metadata within Framework Manager, or does this have to be done at the database level? Thanks

Hi, I have DMR metadata modeled in Framework Manager and I'm displaying this using Analysis Studio. I have one dimension for Status which has a level for category & status. This is being mapped against a measure of 'number of cases'. When I drill down on the category I want all statusus...

Thanks Ties for getting back to me. Maybe I phrased the q wrong though. I have DMR metadata modeled in Framework manager and I want to present this using Analysis Studio. I'm wondering how people run their Analysis studio reports. When we demo the reports should we be demo'ing the html layout...

Hi there, I am trying to model an unbalanced hierarchy in FM and run this in analysis studio but i'm having problems. Structure in db: ORGUNITKEY ORGUNITID ORGUNITNAME ORGUNITLEVEL ORGUNITPARENTID ORGUNITPARENTNAME 1 1 Org A 1 2 2...

Hi, I'm new to Analysis Studio and have come across a few issues over the last week that some might be able to help with. How should cubes be run? They will eventually be embedded in dashboards for us. Should it be the html output that's embedded or the output of when you actually click on the...

Thanks Almeids, Yes, its fine to add it to a query or report as a column but I just want to add it in the header (for example, Report from date: MM/YYYY) so as a text box item. At the moment my text box item calls the parameter like so: ParamDisplayValue(?parameter?). but you cannot seem to...

Hi all, I have a report which takes in two prompts – start and end dates in the format MMYYYY. (It doesn’t take in day values) I can manipulate these values by creating data items in a query and comparing against date values in the database, however when I go to display the values on the...