-
Advance Visualization Charts in Pyramid 2018
Hi Team, Can you please let us where we can find the advance visualization charts in pyramid 2018 Thanks B Rama Krishna Artha Solutions
- Answered
-
Equivalent to SUMPRODUCT in Pyramid
Hi I have to do a weighted average calculation to calculate a market average. In excel I would use sum product where I can't get the numeric value for the %'s and created a weighted average.…
- Answered
-
query a report between dates
Hi, how do I add a simple date filter in order to run a report between dates for example: get all results between 15/10/2017 - 25/10/2017 in pyramid 2018 thanks, Liav
- Answered
-
Connect to SharePoint List in Data Model
Is it possible to connect to a SharePoint list as a source in a data model? I tried various options using the OData source adapter, but could not find a way to get it to work.…
- Answered
-
Cumulative total using Lists
I was looking at creating a measure for the Cumulative Quantities sold over time for individual products. I used the contextual "quick" cumulative measure within the discovery and it seemed to work…
- Answered
-
Prevent New Public Content Folder Creation
In BI Office, a setting in the Admin Console (called Multi-Tenancy within the Networking settings) prevented anyone without admin rights from creating new "top level" folders under the Public…
- Answered
-
Conditional Formatting
I have been converting reports from BI Office to Pyramid 2018 and I have run into a snag. Note that this report was imported from BI Office to Pyramid 2018 using the conversion tool.…
- Answered
-
Weighted Product Distribution %
Good morning, I hope that someone can assist us with calculating a product's weighted distribution in Pyramid. Weighted Distribution % = The Total Value of the Customers that buy a Product (where…
- Answered
-
Pyramid Open AI Evaluation
Hey there, we are currently discussing the open ai integration in pyramid to integrate and therefore need to test that functionality upfront. I cant find the open ai integration in the pyramid…
- Answered
-
Calculate difference between columns
I'm trying to create a very basic grid that has two Terms in the columns and several measures in the rows. How can I add another column that shows the difference between the measures for the terms?…
- Answered
-
What is initial user when changing provider from DB to AD?
What should be the initial user when we change provider from DB to AD? I tried the name of the Enterprise Users created on Pyramid, but it doesn't work.
- Answered
-
Why are my formulas not showing up
I have a handful of formulas that execute successfully in a Public Content folder. However, in Discover, only 2 of them show up Even if it is a blank discover panel.…
- Answered
-
Geospatial map using german zip codes
Hi folks, I try to use the geospatial map visual on an AS cube and have understood that I need to somehow combine cities with their countries, because there might be cities with the same name in…
- Answered
-
Interpreting Timestamps in Repository Log Tables
Administering BI Office often requires querying the repository to understand certain operations and events. This typically involves querying the various log tables.…
- Answered
-
Get data from 2 months ago
Hi, I need to get for a new business logic (AKA formulate section) data dynamically from 2 months ago in order to divide it by data from 1 month ago. I don't have the "2 months ago" filter built-in…
- Answered
-
Cumulative context but to exclude specific status measures (unable to reproduce solution)
Hello, Background: We use Pyramid 2020.13.100 against a SSAS datasource. I'm trying to make the graph above, my assumption is that I should be able to do that if I'm able to make the accompanying…
- Answered
-
Bar chart with multiple measures
Dear all just started working with Pyramid 2018 and I have a question. I want to create a bar chart with dimension: 1 hierarchy values: 3 measures , something like this:…
- Answered
-
Want a appropriate solution for error code RGE-1001.
From the last few days, I have randomly, unable to watch any of the online streaming videos, Actually, I used to watch videos through spectrum app error code rge-1001 is suggested to solve through a…
- Answered
-
Creating a dynamic parameter for a date range
Hi Everyone, I am trying to figure out a solution for the following issue. We have a contract with a start date and and a end date dimension. We want to select the active contracts within a year.…
- Answered
-
Can you change the headers of the columns?
When displaying data in a grid, the column headers are based on the attribute names in the model. Is there a way to rename these columns in the grid?
- Answered
-
Rank
Hi I'm looking to create a rank column as a measure so that I can then say x broker (in slicer) is ranked y out z as dynamic text. I did attempt to use find row number by caption however the caption…
- Answered
-
Publication Trigger for Cube Processing
When scheduling a publication, is there a way to enable a trigger based on whether or not a given cube has been processed? BI Office had this feature. Just wondering if Pyramid 2018 does and I just…
- Answered
-
Sourcing Reporting Services Output in a Data Model
Does anyone know if it is possible to use an SSRS output (CSV, XML, or Excel) as a source in a Data Model? We tried to use the URL option without luck but aren't sure if it is a security problem or…
- Answered
-
Distinct Count if Line Size Value >= Max Line Size for Group
Hi So I have a measure showing count(distinct aggregate reference) and it works as expected but now I need to only count if the line size value is greater than the maximum size allowed for the…
- Answered
-
How to Create a measure from a dimension
I have a dimension for my custom Financial Calendar and I want to add a column to my Discovery which is filtered on Year to show the Max Period. When I try and use MAX(Data Point.…
- Answered
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
Pyramid 2023.12 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help