Search Results

Search results 1-4 of 4.

  • User Avatar

    Dump comments in PALO Excel

    eastehr - - General

    Post

    Hallo Forum, nochmal auf Deutsch (bisher war vielleicht etwas unklar) - Linienmanager und Controller können im Dashboard wunderbar analysieren (z.B. Drilldown auf Produktgruppe Portables, Luxemburg). Sie können dazu auch Maßnahmen in PALO einspeichern (als Kommentar zu den gewählten Koordinaten). - Aber wir möchten gerne eine vollständige Liste aller Maßnahmen in Westeuropa haben. Ich habe mit Subcube und DFilter probiert, aber das setzt alle bis auf eine Dimension als bekannt voraus. Ich suche …

  • User Avatar

    Formatting cells in PALO

    eastehr - - General

    Post

    Thanks axi. However that means I have to get the PALO.DATAC formula (e.g. cells.formula) and use text processing to figure out the parameters. With those parameters I can then figure from PALO attributes the format string. So e.g. formula = activeCell.formulaR1C1 if startswith(formula,"PALO.DATAC(") Then parameters = split(formula,";") for each p in parameters ' if String, fine, if not lookup the cell value which is referred in the formula (e.g. $A$2). Use this cell value to retrieve the formatt…

  • User Avatar

    Formatting cells in PALO

    eastehr - - General

    Post

    Objective - We have reports with a dimension KPI. Some KPIs are defined as ratios with 2 digits, others as percentages and yet others as currencies - We can assign the Excel formatting (e.g. #,###,;[red](#,###,)) as an attribute - Is there any possibilty to elegantly autoformat the cells consistently Alternatives - Use static reports (ugly) - Use a macro (found something here in the forum) to set the formatting - requires quite some knowledge on the report, so needs to be adjusted for every page…

  • User Avatar

    Dump comments in PALO Excel

    eastehr - - General

    Post

    Hi all, I am rather new to PALO, but have some knowledge of VBA. Objective: -We add comments and measures in PALO as comments with relation to certain coordinates - We want to extract a list of all measures relating certain coordinates - Understand how other people work with commentary (using specific commentary cubes or inline of others, how to process it,...) Status Quo: For arguments sake taking the demo database. - We added in the measures a new element called comment. - We have different va…