If you are using the BI Administration Tool for your data modeling, you can create multiple logical table sources within one logical fact table. Whichever logical table source fits the granularity of the analysis will be used for running the analysis. For example, if one table source includes a mapping to both Ledger…

Themis, In all my years using various versions of OBIEE or OAS, it has been my experience that Count(Distinct ) results show a decimal place, and that the default format had to be changed in this way. Perhaps someone had already set the default format for your columns in OBIEE 11g and now that you are in a new system, it…

Themis, While you are on the Data Format tab, can you see a button called "Save as Default?" If yes, then follow these steps: Select the 'Override Default Data Format' checkbox. Change 'Decimal Places' to 0. Click Save as Default button to open a pop-up menu. Select 'Save as the system-wide default for "your column".'

Hello JPorisVU, Are you able to run and download snapshots? If so, I recommend following these steps: Run a Custom snapshot with all optional content deselected Download the snapshot Open the snapshot's local download in 7-Zip or other archive extractor Open the content folder Select the catalog folder and choose the…

@Marcelo G. Proaño , It seems that you intended to include a table in your previous post, but I do not see any table.

@Marcelo G. Proaño , What "table below?" …they would like to export what would be the table below.

Vismay, Try this formula: SUM( Sales BY Sales Representative Identifier)

Can you create a date parameter, which can be used in the Dashboard Filters visualization, and bind your three date filters to the date parameter?

In the "Direct Reportees" analysis, add "Manager ID" as a prompted filter.

Could there be a developer who continues to modify and upload a local version without downloading from server in between?

Try this as the expression: SUM( <measure name> BY <attribute name> )

Many of the regular aggregation functions (as opposed to the running aggregation functions) can use the BY keyword with a list of columns. Here are examples: COUNT( DISTINCT "Form Type" BY "Emp ID" ) max( COUNT( DISTINCT "Form Type" BY "Emp ID" ) by "Emp ID" ) These examples only have one column after the BY keyword, but…

Have you tried changing the Data Access setting to 'Live'? (Open the dataset, go to table's tab, and click the Edit Definition button. The Data Access option is in the right-hand pane.)

Sorry, LukePa. Since you wrote "dashboard filter," I assumed you were using classic, which includes dashboard prompts. In your case, it has to be a parameter, not a variable. The parameter name (e.g., sales_channel) can be inserted in the calculation like this: FILTER( "Cars Sold" USING ( "Sales Channel" LIKE…

Hi Marcelo, Ensure fiscal year and period are on the row which you are clicking, even if they are hidden.

Instead of applying Sales Channel filter to the whole query, only apply it within the column formula using the FILTER() function. To do this, you'll have to set a presentation variable name in the dashboard prompt; e.g., sales_channel. FILTER( "Cars Sold" USING ( "Sales Channel" LIKE '@{sales_channel}{%}' ) ) / "Cars Sold"

You can change the object ID by opening the object and performing a Save As…* The new object ID will reflect the new name. This will create a new object, leaving the original in existence, too. You can delete the original object afterward. If you have other objects dependent on the original object (e.g., workbook used…

Hi @Rajakumar Burra , I recommend you create calculations for Vendor and Quarter using the IFNULL() function, like this: Then you can use this calculated Vendor and Quarter in your pivot table.

Hi Rajakmar, I tried it, and there is a problem. The join between the two tables — when joined on common columns Vendor, Quarter, and Segment — gives multiplied Planned values due to the Actuals break-down by Sub ID. It would be best to join Planned with an aggregated Actuals table, grouped by Vendor, Quarter, and Segment…

Hi GauravSignh, Presuming your BMM has one logical table for DB1.TAB1 columns ("factTAB1") and a second logical table for DB2.TB2 columns ("dimTB2"), with a left outer join between the two logical tables (with factTAB1 on the left) . . . Check the logical table source for dimTB2. Does this table source include DB1.TAB1,…