-
Cascading Slicer question
I have a report that had non-cascading slicers for Course College and Course Department. The report displays Course Section and Attempted Class Count. It made sense to have a cascading slicer for…
- Answered
-
Google Analytics
Hi folks, am I right assuming that Google Analytics can be used as a datasource for the model module, but cannot be queried directly from a discovery? Regards Markus
- Answered
-
The seven success factors of time intelligence
Date-time analysis is a central pillar of modern analytics. Every business needs to track progress over periods of time, and more importantly, compare and evaluate that progress between two time…
-
Change LDAP 389 to LDAP 636
Hi all, as soon as i change the port from 389 to 636 and the LDAP address to LDAPS in the domain settings, the connection no longer works. Does the port 636 in Pyramid not work?
- Answered
-
Access: designate User Defaults
Hi there, As Administrator, I recently stumbled acrossthe "User Default" section via the Access Tab. This function seems to be new and may be used to configure default settings for each user?…
- Answered
-
Defining Custom Color Palette
Hi there, today I used the "more color" option to define a custom color to work within my publication. After generating these Custom Colors, they were availabe in all modules and options where its…
- Answered
-
Question on row sorting
I'm converting a BI Office chart. It's laid out like this: Slices - a date parameter at the month level Columns - Two date calculated members that I have defined in my cube (Current Period and Prior…
- Answered
-
Date Parameter for multiple Date ranges
I have to create a date filter that factors in 3 different date ranges. Total date Cost Date Spent Date Each sum needs to be filtered by it's own date but want to create a parameter for one date…
- Answered
-
List Variable in a Model
Hi, i created an model with a single value variable, it works perfectly. But when i change my variable into a list, my query finds no row. I think i don't use the good syntax.…
- Answered
-
Nested Switch Operators in a Set?
Are nested Switch operators supported in a set? It seems as if the set designer allows you to drag a second Switch operator onto the path of one of the options generated from a first Switch operator,…
- Answered
-
Grand Totals Not Working with Filters
Hi! I don't know if I'm doing something wrong but the Grand Totals are off when you put a filter. It does not recognizes the filtered list, the total is still on the entire data selection.…
- Answered
-
Save Zoom Level on Map
Hello, I have designed a Map showing KPIs as color indicators on a very local level: Retail Stores in a specific area of one city. It is working quite well,…
- Answered
-
CurrentPeriod & StrToDate in an InMemory Model
Hi, I created an InMemory model in which i have Date elements. When i try to use CurrentPeriod or StrToDate functions, syntax control is ok but result is empty,…
- Answered
-
IMDB Engine and Database Questions
We have several questions regarding the IMDB engine and databases that are created/stored there. Is the memory required for a given database the same as the amount of disk space that the database…
- Answered
-
Multiple Members Search
Is it possible to do a multiple Members Search in Pyramid 2018 as it was in BI Office? As you can see in the first example, I'm searching using barcodes to find the members but when I try the same…
- Answered
-
Stacked Visualizations
Hello there, I have some questions regarding the stacked visualizations in combination with measures. I tried to create a stacked column chart with 3 different measures (3 types of costs).…
- Answered
-
URL Too Long when using an action to drive to another report.
Hello I've created a report which I want to use as a detail report. I create an action so that summary reports can drill down into the detail report using "cell".…
- Answered
-
Usage statistics
Hi team I would to ask if in PA 2018 you have embedded a user usage cube as in BI Office. If not is it in planning? Thx Nikos
- Answered
-
Horizontal bar chart with two values
Hello, Is it possible to create a horizontal bar chart with multiple values in PA2018 similar to one attached here. It seems to come easily with a vertical bar chart but for a horizontal one it just…
- Answered
-
Generate Publication Without Title
I want to generate a publication in excel without title(Indicated with red border in image attached). However, I cannot find a way to do so. Can anybody here help or know a workaround to this…
- Answered
-
Cube measure format options
Hello, I see under a measure there is "Properties" with several options to change the cube format of a measure such as #,#.00 | #,#.0 | 0% ... In Bioffice, there was an option to write your own.…
- Answered
-
Creating a waterfall using deduction amounts
Hi I'm not sure if this is possible but I'm hoping to create a type of waterfall chart where you have the Gross Amount as the start point and then a series of deduction types (COM,…
- Answered
-
Sqoop import to HCatalog/Hive - table not visible
HDP-2.4.2.0-258 installed using Ambari 2.2.2.0 I have to import several SQL Server schema which should be accessible via Hive, Pig, MR and any third party(in future). I decided to import in HCatalog.…
- Answered
-
How to set default value to Slicer(Filter) ?
I have week number Slicer(filter). If my current week is 47 then i want to set 47 in slicer.
- Answered
-
Sort multi-select Slicer
Can we sort data of multiselect slicer(Filter)? I have 'Date' slicer. I want to show Date in descending order.
- Answered
Content aside
Topic actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
BARC 2025 BI and Analytics Survey
Pyramid 2024 LTS Release Notes
Pyramid 2023.15 Release Notes
Pyramid Tip of the Day
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help