Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by blueblue

  1. blueblue

    Analysis Studio - visible data

    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...
  2. blueblue

    Analysis Studio - visible data

    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
  3. blueblue

    Analysis Studio - visible data

    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...
  4. blueblue

    Analysis Studio - running cubes & menus

    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...
  5. blueblue

    Unbalanced Hierarchy in DMR modelling

    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...
  6. blueblue

    Analysis Studio - running cubes & menus

    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...
  7. blueblue

    Formatting Prompt Values

    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...
  8. blueblue

    Formatting Prompt Values

    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...
See more

Part and Inventory Search

Back
Top